I have recently converted what once was an Excel workbook with various worksheets into a PDF document with expanding text boxes. Originally, each worksheet was created as a separate form and I then packaged them (the system wouldn't let me bind them into one because they were XML docs). My plan was to package and used bookmarks so that users could jump directly to the worksheet they were interested in at the time. Unfortunately, the 'package' solution was not very functional for the user (took tons of time to load, had to use thumbnails vs. the bookmarks. etc.). My next idea is to simply create one long PDF document (with each form coming one after another) and bookmarking where each separate worksheet begins. However, because the text boxes expand in each document, there is no defined length. A worksheet that would typically start on page 2 may end up starting on page 4 in the document if they were long winded in the first one.
Any ideas on how to make this work? Can you bookmark to worksheet titles vs. Page numbers? Any other suggestions?
As long all worksheets are in one single form, you can use XFA bookmarks, that behave like those in a regular PDF.
There is no module in Designers UI to create those booksmarks, so you would have to add them in the XML source manually.
Or, you use this macro to add bookmarks (required Designer ES3 or higher).