I currently receive PDF reports from 3 different providers, covering over 650 sites, each report is on a different aspect. Reports range from 1 page to 10 pages. Using this site and with some self learning I have managed to construct several marcos in VBA to sort the reports into the individual sites, create folders for the sites and combine the reports for that site into a single PDF.

The problem I have now is management want me to add in bookmarks for each report and the bookmark is to be the name of the report.

My current process is as follows:
example for Site One
Provider 1 sends in 2 reports named FAC.pdf and RDS.pdf
Provider 2 sends in 3 reports named A.pdf, B.pdf and C.pdf
Provider 3 sends in 1 report named Z.pdf

I create folder called Site One and move the files into the folder
I then list the Folder and the files within on the sprreadsheet
I then loop through the sites and create a single PDF per site.
The resulting PDF is then placed into the site folder.

What I now need to do is create the PDF with the following filenames as bookmarks FAC, RDS, A, B, C and Z

Can anyone help I'm using Excel 2003 and VBA, Acrobat 8.0

Happy to post the code I use if that will help?