Combining PDFs
 

I have a list of PDF filenames in a worksheet. There are 2 columns; each
containing a filename and 100+ rows. For each row i want to merge 2 files in
1 new file. the new filename is column 3.
as the number of file involved is quite a lot, i want to automate this task.
How can i do this in excel vba?