Merging PDF files using VBA and PDFSam Basic

[Yolandi]

Good morning,
Please can someone help me?
I have tried numerous codes but my company only uses PDFsam Basic, is there a code where I can merge 2 or more PDFs using VBA and PDFsam Basic?

I have 3 Columns, Column A is the first file path with file name, Column B is the second and Column C is the new File path and File name.

 

[alansidman]

You might want to try bringing your PDF files into Power Query and then joining the two queries. Look at this video for a tutorial

 

[Yolandi]

You might want to try bringing your PDF files into Power Query and then joining the two queries. Look at this video for a tutorial

Unfortunately my company doesnt have power query, and we are still using Microsoft 2016

 

[alansidman]

XL 2016 has power query built in as a native function. You will find it called Get and Transform Data and it is found on the Data Tab of the Ribbon. The exercise you are describing is perfect for PQ and will save you lots of time and energy.

Please update your profile to reflect your XL version. It makes a difference when members are offering up solutions.