Merge PDF files using excel VBA

[mohamedboussaida]

This is my first time posting into the forum, i need help of the experts

i have 800 pdf files in folder A

i have 800 pdf files in forlder B

both folders files have same name, example: in folder A: file 10005555.pdf (C:\Users\mohamedboussaida\Desktop\PDF Merge\SET A)
in folder B: file 10005555.pdf (C:\Users\mohamedboussaida\Desktop\PDF Merge\SET B)

i want to merge both files based on their names noting that the file in folder A shall take place in top of the merged final final
is there any vba code from excel to do this merging / combination instead of doing it one by one
i highly appreciate your help to save my time and life

 

[Macropod]

This really has very little to do with Excel; it could be done equally well (or poorly) from any Office application.
What version of Office do you use?
Do you have Adobe Acrobat Professional installed?

 

[mohamedboussaida]

This really has very little to do with Excel; it could be done equally well (or poorly) from any Office application.
What version of Office do you use?
Do you have Adobe Acrobat Professional installed?

i am using MS office 2010 and adobe professional is installed as well in my computer, my query is to find out a way to make these merging of the 800 pdf file using a program / vba but i don't know the code of this vba to be used, i will highly appreciate if you can assist me on this request. thanks in advance

 

[Macropod]

In that case, you'd need to write code to automate Adobe Acrobat Professional and use its functionality for the file merging. Looping the folders with parallel content is fairly straightforward (see, for example, [SOLVED] Generate tables to insert pictures from different folders), but I'm not overly familiar with the Adobe Acrobat Professional API.