Merge PDF using VBA

[Orloff34]

Dear forum,

we are using PDF-XChange Editor Plus (Version 8.0, Windows 10) in our company. For my task I need to merge several pdf files created with Excel to single pdf file using VBA.

I could do this command line but I am asking myself whether there is also an API available to do this task.

I want to replace the following command line:

Code: Select all

PDFXTools.exe /RunTool:showui=no;showprog=no splitMergePDF d:\T1.pdf d:\T2.pdf /Output:folder=D:\;filename=Merge.pdf;showfiles=no;overwrite=yes

But I experienced some runtime issues using this command and adding the files with for loop to add the files consecutivly with following command

Code: Select all

PDFXTools.exe /RunTool:showui=no;showprog=no splitMergePDF d:\Merge.pdf d:\T(i).pdf /Output:folder=D:\;filename=Merge.pdf;showfiles=no;overwrite=yes.

The command is adding a file to the already existing Merge.pdf and is overwriting itself. This works well until the file Merge.pdf gets larger and next command line call is performed before the previous is finished and Merge.pdf is still in use.

So any ideas who to solve issue? Can I create file list and handle it via the command line? Or is there an API which I can use avoiding this problems?

Best regards
Orloff34

[John - Tracker Supp]

Hi,

accessing the API using an End User license is prohibited under the terms of the license I am afraid.

[Orloff34]

What about creating a file list as a .txt file with the path and filename and pass the txt file via the command line to the splitMergePDF Tool?

Best regards
Orloff34

[TrackerSupp-Daniel]

Hi, Orloff34

PDF-tools does indeed offer a "filelist" function, as well as numerous other configurable "actions". You can follow the steps here to create a custom tool which will do exactly as you need, and then use the command line functions here to run it without trouble.

Kind regards,

[Orloff34]

Hi Daniel,

thank you for your support. After following the knowledge base and using the correct command line options it works fine even with 80 single files creating a single pdf of about 35 MB...

Best regards
Orlofff34

[TrackerSupp-Daniel]