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?

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



"DevDaniel" wrote:

> 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?