excel tp pdf

[Guest]

Hi

I wondered if anyone had any suggestions on how to save a spreadsheet to pdf
format using vba code

 

[Guest]

Using XL 2003 and perhaps the last couple versions before that, you must
have the Acrobat writer installed on your machine (i.e. just Reader won't cut
it).

If you have it, you can record a macro in XL where you change the printer
(File then Print menu) to "Adobe PDF" and print a document; then copy that
macro to your code. That may be the easiest way.

HTH

 

[Guest]

If the $$ for full Adobe Acrobat is a problem, there are also some free
downloads that create .pdf files. I have one called PrimoPDF, and it works
fine. Like Acrobat, when you install it, it creates a new "virtual printer."

 

[Stephen Plotnick]

Excel 2007 has an add-on for PDF publishing. It is easy to do using VB

 

[Guest]

ok but that only gives me code to print the document not the code to
save/convert the document to pdf

 

[NickHK]

No, it lets you "print" to pdf as the printer virtually; no paper involved.
It is really a Save.

NickHK

 

[Guest]

Hi Nick

Yes I see that now thanks.

But(sorry to be a pain) this needs manual intervention to save the document
+ if I was running/creating more than 1 document I get an error if the pdf
print page is not closed down.

 

[NickHK]

Working Adobe Acrobat, methods of automation depend on the version
installed.
Other free pdf printers are available that make automation somewhat simpler;
maybe look at one of those.

NickHK