VBA to combine PDFs

[faops]

Hi All

I'm creating a customized cover page for each client (pdf) that needs to be merged with a static master presentation (also in pdf).

I have the following
COL A: filepath of cover page with .pdf extention (filename is customized to each client)
COL B: file path of master deck (this is a dingle file so static)

Is there a VBA code I can use to combine the two PDFs and save in a particular folder. I have Adobe pro as well.

I'm a beginner in VBA and hope i can get some guidance

 

[John_w]

This code should work for you, noting that column C is the file path of the merged PDF. Data starts at row 2.

Combine multiple PDF files with VBA

Dear VBA Specialists, I want to create a macro which merges multiple PDF files, but the amount of files that has to be merged is variable and need to be determined in the excelsheet. So my wish is to gain a VBA code that reads the filenames out of a folder, Somehow select which ones should...

www.mrexcel.com

 

[faops]

This code should work for you, noting that column C is the file path of the merged PDF. Data starts at row 2.

Combine multiple PDF files with VBA

Dear VBA Specialists, I want to create a macro which merges multiple PDF files, but the amount of files that has to be merged is variable and need to be determined in the excelsheet. So my wish is to gain a VBA code that reads the filenames out of a folder, Somehow select which ones should...

www.mrexcel.com

Thank you John this works perfectly. Much appreciated