Macro to combine multiple pdfs and create multiple outputs

[Nandulal]

Dear VBA specialist,

I'm trying to write a code that will pick path and name of the PDF from the excel file and merge it or combine it, my specific requirement is it should pic PDF1 path from column A, PDF1 name from column B, PDF2 Path from column C, PDF2 name from column D, PDF3 path from column E, Pdf3 name from F and combine all the three pdf and create a new merged pdf and save in the path given in the column G and name in H, it should pic one row and create one merged PDF likewise create multiple Merged PDFs, below the example table.

Highly appreciate your help

PDF1 Path	PDF1 Name	PDF2 Path	PDF2 name	PDF3 Path	PDF3 name	Saveing path	Combined file name
\\corp\aimusroot\DEPARTMENTS	Test1.pdf	\\corp\aimusroot\DEPARTMENTS	Test1.pdf	\\corp\aimusroot\DEPARTMENTS	Test1.pdf	\\corp\aimusroot\DEPARTMENTS	Final1.pdf
\\corp\aimusroot\DEPARTMENTS	Test2.pdf	\\corp\aimusroot\DEPARTMENTS	Test2.pdf	\\corp\aimusroot\DEPARTMENTS	Test2.pdf	\\corp\aimusroot\DEPARTMENTS	Final2.pdf
\\corp\aimusroot\DEPARTMENTS	Test3.pdf	\\corp\aimusroot\DEPARTMENTS	Test3.pdf	\\corp\aimusroot\DEPARTMENTS	Test3.pdf	\\corp\aimusroot\DEPARTMENTS	Final3.pdf

Thank you,
Nandulal

 

[John_w]

If you have Acrobat Pro installed this can be done by calling Acrobat API functions from VBA.

Alternatively a command-line tool such as PDFtk Server can be called from VBA to merge the PDFs, specifically the cat command. Example code at VBA Export diferent excel files to pdf and then combine them to one file, which needs adapting for your situation.

 

[Nandulal]

Thank you Jhon,
I will work on it and come back to you if i face any issues

 

[alansidman]

Here is an alternative to VBA. Use Power Query to append multiple PDF files. Once combined, you can then save the Excel file back to a PDF. Easy Peasy!