Automate Excel Output to Pdf via PDF995 software

[sanful]

I attempted to use the software pfd995 to create a pdf file from excel. This works seamlessly when I use the print dialog box and enter the filename. However, I would like to automate this step and bypass the print/filename dialog boxes by using a print command button via vba. Does anyone know how to select the pdf printer and automate the filename via vba in excel?

The pdf995 website has not proven to be of any help. I am at wit's end! Any help would be greatly appreciated!!!

 

[PHV]

Have you tried to use the Macro recorder ?

Hope This Help
PH.

 

[Phil92]

Good evening,

If it is not too late, here is the address of the Developer's FAQ. Maybe, you 'll find an example there.

http://www.pdf995.com/faq_dev.html

HTH

Phil

 

[sanful]

It's never too late! Thanks.