These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Acrobat with VBA

Vlilly
Registered: May 9 2007
Posts: 4

I run hundreds of reports each month. This process is automated using VBA from Excel. All reports are saved as a .pdf file. Can you tell me how I can include the 'saving to .pdf' in my VBA code? At this point it is a manual process and can be quite time consuming.

My Product Information:
Acrobat Pro 8, Windows
thomp
Expert
Registered: Feb 15 2006
Posts: 4411
You can use the Acrobat Inter Application Communication Interface. Look for the related documents at

[url=http://www.adobe.com/devnet/acrobat/]http://www.adobe.com/devnet/acrobat/[/url]

All you have to do is tell Acrobat to open the excel file and it will automatically convert it.

Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script