need excel vba help wtith making pdf files

[mihael]

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:

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:

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]

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


.

 

[mihael]

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!

 

[ignatzatsonic]

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!!

 

[mihael]

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.

 

[ignatzatsonic]

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]

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!

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.

I can certainly feel it!

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

.

 

[mihael]

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.

 

[mihael]

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...

 

[mikedl]

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.

 

[nailgunner]

I did read the original question, so this is for the others who might be reading the posts.

There is another option. If you have the drive space for the program, Open Office has a nice tab that will quickly convert and save an Excel file as a PDF. Done it a few times and it takes about 5 seconds.

 

[Irene]

I cannot see the reason to use VBA at all.

Save the spreadsheet as a PDF file, by selecting from the drop-down menu.
Open the pdf file and select the printer.

Am I really missing something here?
.
.

 

[mikedl]

Hi, Irene. I do it to save steps. One chunk of VBA code converts it to a PDF, saves it to a file, prints it and prepares a blank email with the file attached.

 

[Irene]

Hi, Irene. I do it to save steps. One chunk of VBA code converts it to a PDF, saves it to a file, prints it and prepares a blank email with the file attached.

Thanks for the explanation, Mike. I was beginning to think I was losing it.

At my time in life, the pressure for speed is significantly reduced.
Still, it's good to learn something new every day - and I certainly do on this forum.