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 hyperlinks into bookmarks.
- 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?