Combine Multiple PDFs Using VBA

[avpenaloza]

Creating a new thread for additional help - previous thread:
Combine multiple PDF files with VBA

I am trying to merge PDFs. I have a set of PDFs in Folder A, a set of PDFs in Folder B, and I want them merged into Folder C.
In Folder A, there is 1 PDF that will be matched with a variable number of PDFs in Folder B.

I set the excel spreadsheet up like this and tried the code given to me in the previous thread and something worked.
But I am thinking maybe I set my spreadsheet up wrong because the outputs (Test2 and Test3) were overridden by the previous rows. Only the last row of each duplicate NewFile was merged.

Is there a better way I can set up my spreadsheet so that if 1 PDF from Folder A is going to be merged with say 20 PDFs from Folder B they don't just override each other?

Thank you so much for your help in advance @John_w !

File Path 1	File Path 2	NewFile
C:\Users\apenaloza\Documents\Attachments\Test.pdf	C:\Users\apenaloza\Desktop\Working\Macro Test\Invoice 1.pdf	C:\Users\apenaloza\Desktop\Working\Macro Test OUTPUT\Test1.pdf
C:\Users\apenaloza\Documents\Attachments\Test1.pdf	C:\Users\apenaloza\Desktop\Working\Macro Test\Invoice 2.pdf	C:\Users\apenaloza\Desktop\Working\Macro Test OUTPUT\Test2.pdf
C:\Users\apenaloza\Documents\Attachments\Test1.pdf	C:\Users\apenaloza\Desktop\Working\Macro Test\Invoice 3.pdf	C:\Users\apenaloza\Desktop\Working\Macro Test OUTPUT\Test2.pdf
C:\Users\apenaloza\Documents\Attachments\Test2.pdf	C:\Users\apenaloza\Desktop\Working\Macro Test\Invoice 4.pdf	C:\Users\apenaloza\Desktop\Working\Macro Test OUTPUT\Test3.pdf
C:\Users\apenaloza\Documents\Attachments\Test2.pdf	C:\Users\apenaloza\Desktop\Working\Macro Test\Invoice 5.pdf	C:\Users\apenaloza\Desktop\Working\Macro Test OUTPUT\Test3.pdf
C:\Users\apenaloza\Documents\Attachments\Test2.pdf	C:\Users\apenaloza\Desktop\Working\Macro Test\Invoice 6.pdf	C:\Users\apenaloza\Desktop\Working\Macro Test OUTPUT\Test3.pdf
C:\Users\apenaloza\Documents\Attachments\Test2.pdf	C:\Users\apenaloza\Desktop\Working\Macro Test\Invoice 7.pdf	C:\Users\apenaloza\Desktop\Working\Macro Test OUTPUT\Test3.pdf

 

[John_w]

But I am thinking maybe I set my spreadsheet up wrong because the outputs (Test2 and Test3) were overridden by the previous rows. Only the last row of each duplicate NewFile was merged.

Is there a better way I can set up my spreadsheet so that if 1 PDF from Folder A is going to be merged with say 20 PDFs from Folder B they don't just override each other?

You can't have 2 files with the same name in a folder. Therefore make the column C file names unique.