'Create PDF bookmarks Within Excel Workbook

I'm attempting to build a monthly process that converts an excel file to a PDF with bookmarks for each respective sheet. I'm not seeing a method to successfully create PDF bookmarks from within the Excel workbook. Can this be accomplished without third-party software?

What I've tried:

  • Using Header 1 for a cell as well as an entire row.
  • Putting Excel Book Mark within the file using a hyperlink reference.
  • Adding named range.
  • OneDrive flow Convert File
  • Adding a Header.
  • Reviewed some VBA Ref libraries hoping to find an object.bookmark type approach.

Unfortunately, all attempts have resulted in a PDF file with no bookmarks.

Is there a method to create PDF Bookmarks from Excel? Possibly a VBA ref library that I am unaware of or some front-end trick? Unfortunately, I'm stuck working only with Microsoft tools. Adobe's Excel Add-On does exactly what I'm trying to achieve.

excelvbapdfjavasnowflake-cloud-data-platform


Solution 1:[1]

according to notes on this page

getConcurrency() - method returns concurrency mode of this ResultSet object. It may be CONCUR_READ_ONLY (1007) or CONCUR_UPDATABLE (1008)

it implies your selection of CONCUR_UPDATABLE is not supported.

This page suggests that feature allows you to alter the result set you get back from the database, and thus if you don't use that ability, maybe you should not ask for it. And if you need it, it seems you cannot have it.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Simeon Pilgrim

Related Questions