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