Hi

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

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

"laughing gravy" wrote:

Hi

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

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

"laughing gravy" wrote:

Hi

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

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

"LarryP" wrote in message
...
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."

"laughing gravy" wrote:

Hi

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

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


"XP" wrote:


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

"laughing gravy" wrote:

Hi

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

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

NickHK

"laughing gravy" wrote in message
...
ok but that only gives me code to print the document not the code to
save/convert the document to pdf


"XP" wrote:


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

"laughing gravy" wrote:

Hi

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

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" wrote:

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

NickHK

"laughing gravy" wrote in message
...
ok but that only gives me code to print the document not the code to
save/convert the document to pdf


"XP" wrote:


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

"laughing gravy" wrote:

Hi

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

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

"laughing gravy" wrote in message
...
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" wrote:

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

NickHK

"laughing gravy" wrote in
message
...
ok but that only gives me code to print the document not the code to
save/convert the document to pdf


"XP" wrote:


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

"laughing gravy" wrote:

Hi

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