VBA to Merge Multiple PDFs

[michele227]

Hi everyone!

My work doesn't want to pay for the full Adobe version...
I would like to merge PDFs.

Is there a VBA to open up a File Dialog (path to be referenced in Sheet1 Cell O17)..
and allow me to select the files needed..
and then merge them together into 1 PDF with a specified name in Sheet1 Cell N2 and saved to the same path in O17?

I may be asking for too much here .

Thank you in advance!

 

[jdellasala]

Instead of VBA, you might want to try importing the PDFs with Power Query which can then merge or append them into a table which can then be saved as a PDF.

 

[michele227]

Instead of VBA, you might want to try importing the PDFs with Power Query which can then merge or append them into a table which can then be saved as a PDF.

Hi J,

The PDFs I am looking to merge would be appliance specs that require dimensions and images to remain as is.

 

[jdellasala]

Hi J,

The PDFs I am looking to merge would be appliance specs that require dimensions and images to remain as is.

I'm not aware of any free apps that would do that. I'd use Acrobat DC. Excel is certainly not the place to look!