Hello,

I am looking for an alternative to ExportAsFixedFormat for printing to PDF.
I am wanting to use the Save as Adobe PDF option in Excel. If you use this, you can print to PDF and it creates the bookmarks for each sheet.
The reason this would be nice is that I am creating a batch of reports to send to managers and they could easily use the bookmarks within the PDF to get to each report.
Is there another solution? I believe the above Save as Adobe PDF in VBA would use the Adobe API (Acrobat Reference Library). I am just not well versed in VBA (decent at modifying VBA) and APIs to know where to start.

Any help would be appreciated!