Merge multiple PDFs based on path in excel row - VBA

[casey2]

Hi everyone,

I have a excel file in the shown format.

column A - i have full paths of 100's of pdf

Column B - Name of the pdfs.

I need a VBA program to merge, all the pdf in column A in to a single pdf in the same order as in coulmn A.

Format is as shown below. There may be upto 200 rows.


-- removed inline image ---


Please help me experts.

Thanks,
Casey