Need to add bookmarks in Excel to PDF file?

[dscrugham]

Working with:
Excel 2003
Acrobat Distiller 8
Adobe Acrobat 8 Standard

What I want to do is automate the creation of the PDF from Excel with bookmarks for each sheet in the workbook with VBA.

I have a workbook with 100+ sheets. With the Excel book open, I can click on the 'Convert to Adobe PDF-Acrobat PDFMaker' icon, it will create bookmarks as expected, as I have the application settings checked to 'Add Bookmarks'.

I have found code snippets which call the distiller but it doesn't add the bookmarks. Any suggestions or links that I can research to add bookmarks?

Thanks