Code to Run PDF Maker

[Guest]

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?

 

[Guest]

I found a workaround on the PlanetPDF website. It launches the PDFMaker
button on the PDFMaker 7.0 toolbar. The code for launching the button is:

Dim cbar As CommandBar

For Each cbar In CommandBars
If cbar.Type = msoBarTypeNormal Then
If cbar.Name = "PDFMaker 7.0" Then
cbar.Controls(1).Execute ' press 1st button on PDFMaker 7.0
toolbar
End If
End If
Next cbar