Combining PDF files from a folder using a list from excel (not importing to excel, combining as a single PDF)

[Patrick Desarzens]

Years ago I worked in a company where we had to submit pre-qualification packages. The company had all project summaries and staff bio's used for these pre-quals as a single PDF per project. An excel file was used that had a list of these files with filters and check boxes. You could filter by project categories to narrow the resulting list, then check box the ones you wanted. Once selection was complete a single button in excel would open each of the selected PDF files and combine them as a single PDF with a file name you entered prior to pushing the combine button.

Finding myself in need of this function, but can't locate anything online. All searches are showing how to extract PDF content from multiple files into excel -can't find anything that matches the function I describe above.

 

[John_w]

Given the selected multiple PDF files, you can merge them to a single PDF using a VBA procedure which calls one of the following:

• Acrobat API - only available if Acrobat Pro is installed, not the free Adobe Reader.
• A third-party tool such as PDFtk Server. Its cat command can be called from VBA to merge a list of PDFs.

 

[Patrick Desarzens]

Given the selected multiple PDF files, you can merge them to a single PDF using a VBA procedure which calls one of the following:

• Acrobat API - only available if Acrobat Pro is installed, not the free Adobe Reader.
• A third-party tool such as PDFtk Server. Its cat command can be called from VBA to merge a list of PDFs.

Thanks for sharing these ideas - will look into them