need excel vba help wtith making pdf files

Hi, I would like to save my excel sheet as PDF + print that sheet on my local printer (so changing default printer to Adobe PDF printer will not work)

I searched help database and I found two commands that by my logics could work - PRINTOUT and EXPORTASFIXEDFORMAT.
Now for the first comand I wrote:

Code:

 
Sub Macro1()
Application.Activate = "Adobe_PDF_Converter" 'that's how my pdf printer is labeld
ActiveSheet.PrintOut prewiew:=False, _
ActivePrinter:=Adobe_PDF_Converter, _
printofile:=True, _
PrToFileName:="C:\users\borut\desktop\primer.pdf"
End Sub

but I get the error
runtime error '438':
object doesn't support this property or method

and for the second:

Code:

 
Sub Macro2()
ActiveDocument.ExportAsFixedFormat OutputFileName:= _
"C:\Users\borut\Desktop\test.pdf", ExportFormat:=xlTypePDF
End Sub

but I got the error:
runtime error '424':
object required

Irene said:

Here is a MicroSoft add-in for that purpose in Office 2007...
Download details: 2007 Microsoft Office Add-in: Microsoft Save as PDF


.

Does anyone here read the questions???

Office 2007+ allow to save as PDF, plus I have adobe PDF printer. What I need is help with the macro code!

I have an Excel macro that works, but I am far far from an authority or knowledgeable. I eventually got it to work through fumbling, trial and error, and googling.

Google generates 630,000 hits for "runtime error 438". I can only suggest you drill into some of them.

But only 47 for "runtime error 434". Hmmmm.......................

I'd look at 434 rather than 438.

Microsoft used to have a series of Excel newsgroups, but I think they have been replaced by online forums similar to this one.

Good luck. Put on your sheepskin chaps and put a knife in your teeth. You may be in for a long haul and a lot of frustration.

But they are very cool when finished and they work!!

ignatzatsonic said:

I have an Excel macro that works, but I am far far from an authority or knowledgeable. I eventually got it to work through fumbling, trial and error, and googling.

Google generates 630,000 hits for "runtime error 438". I can only suggest you drill into some of them.

But only 47 for "runtime error 434". Hmmmm.......................

I'd look at 434 rather than 438.

Microsoft used to have a series of Excel newsgroups, but I think they have been replaced by online forums similar to this one.

Good luck. Put on your sheepskin chaps and put a knife in your teeth. You may be in for a long haul and a lot of frustration.

But they are very cool when finished and they work!!

The answer should be simple and easy, of course for someone that knows where the problem is. I googled it, but as you mentioned did not help me, even with my knife beetwen my teeth.

No doubt it's simple----------------once you know how.

Look here:

VBA Express Forum - Supercharge Your Microsoft Office Applications

or


MrExcel.com | Excel Resources | Excel Seminars | Excel Products


or here


http://www.excelforum.com/

Irene said:

Did anyone mention to you that this is the season of goodwill?
Attitude does not produce answers...

...answers like yours are not even answers since you don't read a question. I don't want to be rude, but if I don't know a thing about a topic in the question I don't give a useless advice.

ignatzatsonic said:

No doubt it's simple----------------once you know how.

Look here:

VBA Express Forum - Supercharge Your Microsoft Office Applications

or


MrExcel.com | Excel Resources | Excel Seminars | Excel Products


or here


Excel Help Forum

I tried to register on the VBA Express Forum but I don't get any confirmation email on my gmail, I aslo sended email to administrator that I dind't receive their confirmation email and I didn't get any reply (that was three days ago)

I aslo tried on VB.Forums and jet no answer...

mihael said:

Irene said:

Did anyone mention to you that this is the season of goodwill?
Attitude does not produce answers...

...answers like yours are not even answers since you don't read a question. I don't want to be rude, but if I don't know a thing about a topic in the question I don't give a useless advice.

Hang on, mihael! I've got the answer you are seeking, I use it all of the time in conjunction with my AutoCad Architecture PDF files I create for clients. I use Access to do general billing but create complicated bids with Excel, convert to a PDF and then print. I also prepare an email for the client by starting a new mail and attaching the PDF in the same VBA code.

If you had been a little nicer I might have posted the code for you.