VB Code to Merge 2 pdf in one

[rmomin]

Hello:

I have 2 pdf in folder C:\TempA\,
Eaxmple file name : Abc23445443.pdf and xyz5443.pdf

I need VB Code to merge these 2 pdf in one and put in folder C:\TempB\ as Merged.pdf

Note:
The pdf file with the longest name will be 1st and then the other file

In this case:
Abc23445443.pdf
xyz5443.pdf

Let me know if you have any questions.



Riz

[6StringJazzer]

Excel can't do this, unless you can reference the library for Adobe Acrobat Professional, which means you have to have it installed.

There are tools that can merge PDF documents for free, but I am unaware of any that can be called programmatically from Excel.

[rmomin]

Hello:

I have reference Adobe Acrobet Pro,

R

[6StringJazzer]

As seen at https://wellsr.com/vba/2017/word/com...adobe-acrobat/

Set up code to put the two files into an array then call this function with that array, plus the name of the resulting merged file.

Please Login or Register  to view this content.

[alansidman]

Riz
Are you still using XL2010 or a later version?