Code to Run PDF Maker
I have:
Excel 2003 and Acrobat 7.0 Pro installed on my PC. The Excel file has many
worksheets (150+) and many relative hyperlinks. I have 900+ Excel files to
convert, so I need an automated solution.
I want:
Excel VBA code to run the PDF Maker.
- I tried printing the file to the Acrobat PDF printer, but this does not
convert the bookmarks into hyperlinks.
- Using Adobe PDF Convert to Adobe PDF converted the hyperlinks, but this
is a manual process I want to automate.
- I tried the Excel Create Macro tool to get the code, but it did not record
the Adobe PDF menu commands.
Any suggestions?
|