VBA Export to PDF with Adobe Acrobat API

[tjdickinson]

I am running a macro that executes numerous operations on a file, and I want it to automatically save and export to PDF at the end. It must use the Acrobat add-in, not Excel's built-in PDF conversion, because each sheet needs to be bookmarked in the output (and that's not possible with the built-in engine).

I'm still quite green when it comes to VBA, and even more ignorant when it comes to Adobe API. So I need help.

Here are the parameters I need:

• Create PDF: entire workbook, actual size << these are the options in the 'Create PDF' window of the Acrobat add-on. Each file I have has a different number of pages.
• Conversion settings: Standard(1) << custom settings which includes adding bookmarks for each worksheet
• Location: parent directory (up one directory from the location of the Excel file)
• File name:
  • The Excel file name will look something like this: 21-22 January v6.R3.1234 ... _Leerkrachten
  • After the 1234, there may be additional text which should be removed from the PDF file name
  • The suffix _Leerkrachten should be replaced with _LK
    Two other possible suffixes: _Leerlingen >> _LL // _pauze >> _TZ
• Do not view file on export

Thank you in advance for any help you can give!

 

[tjdickinson]

Query updated and reposted here.