New Forum | Previous | Next | (P-PDF) Beginners
Topic: how do you add bookmarks dynamically when creating a pdf file from excel97?
Conf: (P-PDF) Beginners, Msg: 111249
Date: 5/11/2004 02:13 PM
I have an excel97 file I need to turn into a pdf file, the excel file has about 18 tabs and the pdf creation tool allows for creation using a little VBA from the main page. the problem is I need to create bookmarks for each tab dynamically when I create the pdf file, I can't afford the time to do the bookmarks manually, and some of the tabs will be changing size by a couple of pages a week. my company is running both acrobat 5 and 6. a book I bought says that bookmarks can be added dynamically during the creation process, but I don't have the proper pages showing when I try to create the file and was wondering if anyone knows a way to get around this. I'm looking for a way to create the bookmarks from the calling program, then I can use the macro recorder in excel to generate a function that can be called when the spreadsheet runs.
thanks in advance.