Skip to main content
Participant
February 20, 2018
Question

creating a single PDF file by combining a collection of different file types using VBA

  • February 20, 2018
  • 1 reply
  • 335 views

Hi -

Does anyone know how to use VBA (in Microsoft Access) to create a single PDF file by combining a collection of different file types (.docx, .pdf, .pptx, .jpg, .xlsx, etc)?  Basically I want to loop through a windows 7 directory and create a PDF file of everything in it.  I can do it manually right now by just selecting them all and right-clicking to use the menu option, but it sure would be nice to automate.

Thank you for any help -

Dan

This topic has been closed for replies.

1 reply

Thom Parker
Community Expert
Community Expert
February 20, 2018

Have you thought about using an Acrobat Action? or the Portfolio tools? 

But if you want to do it with VBA, then read this part of the Acrobat SDK manual in the IAC:

Acrobat DC SDK Documentation

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often