Hi.....

I need to run code that will print an excel workbook to a pdf file.
Here's what I got when I recorded the macro to do it..

Application.ActivePrinter = "Adobe PDF on Ne04:"
ActiveWorkbook.PrintOut Copies:=1, Collate:=True


(Not sure if this will work for others using different versions of Adobe
Writer..???).

Anyway.. I need the code to check to see if the user has Adobe Writer
software (or software that will allow them to print to a pdf file) and if
they do not ...then a message states "cannot print to pdf" and if they
do..then it prints to the pdf file.

Not sure if this is possible... so any help is greatly appreciated..

Thanks in advance!
Kimberly

http://groups-beta.google.com/advanced_search

--
Regards,
Tom Ogilvy

"KimberlyC" wrote in message
...
Hi.....

I need to run code that will print an excel workbook to a pdf file.
Here's what I got when I recorded the macro to do it..

Application.ActivePrinter = "Adobe PDF on Ne04:"
ActiveWorkbook.PrintOut Copies:=1, Collate:=True


(Not sure if this will work for others using different versions of Adobe
Writer..???).

Anyway.. I need the code to check to see if the user has Adobe Writer
software (or software that will allow them to print to a pdf file) and if
they do not ...then a message states "cannot print to pdf" and if they
do..then it prints to the pdf file.

Not sure if this is possible... so any help is greatly appreciated..

Thanks in advance!
Kimberly