printing to a pdf file

K

KimberlyC

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing to pdf 3
Print to PDF code for both Cute PDF and Adobe 1
PowerPoint Printing PPT to PDF without losing quality 1
Print to PDF 2
Print to PDF using Adobe Acrobat 6.0 2
Print To pdf Not Working 6
How can I get a list of the available printer names? 1
Bypass "Save PDF File As" Prompt via VBA in Excel 0

Top