Involking Adobe Batch Combine & bookmarks.

[Tony Martin]

I am putting a Excel Macro together that constructs a series of charts and (Ultimately) puts them all in a single PDF file.
I am using Windows XP. Office 2003 and Adobe Acrobat 6.0 (The full product, not just the reader)

The spreadsheet constructs 70 charts and they are all constructed on the same space. In other words, a chart is created, printed, then destroyed so the sheet area can be re-used for the next chart. It gets created & printed, then destroyed for the next, etc...
Since there are 70 charts, it would be really nice if there would be a way to programmatically add bookmarks to the PDF so end users can easily jump around the file.

What I've gotten so far is a simple loop that uses the Adobe Distiller. This results in 70 PDF's but it's a start right?
I can't figure out how to invoke the Batch Merge feature of the Acrobat Program to combine them all into a single PDF or how to add bookmarks to it.
Any help would be appreciated.
Thanks!

[RobDog888]

Sounds like an Acrobat question that you may get a better response for from Adobe. You can sign up for free as a registered
member and get some free downloads of Acrobat SDKs.