Merge PDF file with same Identical Name|VBA & Macros|Excel Forum|My Online Training Hub

Hello Everyone,

I want here to generate

 files from an 

 file. After this coding runs, the results is that I will have multiple 

 files with suffix 

 - (e.g., 

) I can change the suffix to anything.

And I will extract another set of PDF files from a zip file that have the identical file name as 

.

At the end, in one folder, there will be multiple pairs of files as below.

875458.pdf
875458-index.pdf
875460.pdf
875460-index.pdf
954784.pdf
954784-index.pdf

My goal is to find a way to merge each pair of files into one file.

The end result would be as below.

(Index file being the first pages)

875458.pdf 
875460.pdf
954784.pdf

If someone can kindly shows me the following, I would appreciate it greatly.

Thanks
Deepak Kumar