VBA to combine multiple PDF Pages - VBA PDF Automation-7

Friendly tutorial to Automate PDF using real-world scenarios using VBA and PDF API.

Subscribe, Like, and Comment. 🙏Thanks for watching.

You can now support by buying any of the Projects or Source Code.

📌What to watch next:

#VbaA2z

[kiwimp]

Do you have a video about how to set up the Acrobat API on a machine that deosn't have Acrobat DC?

[Megaawsomeberry]

Having an issue trying to add third document in this code. Can you please describe the setup? I created a toDoc1 and specified the file path and included the insert pages code is this...

If toDoc.InsertPages(1, fromDoc, 0, fromDoc.GetNumPages(), True) = False Then
Debug.Print "Failed to Insert the Page"
End If
If toDoc1.InsertPages(1, fromDoc, 0, fromDoc.GetNumPages(), True) = False Then
Debug.Print "Failed to Insert the Page"
End If
If toDoc.Save(PDSaveFull, "FilePath") = False Then
Debug.Print "Failed to save"
Else
Debug.Print "Failed to Save"
End If

Please Advise.
Thanks

[angelajimenez]

Code works great! As you mentioned at the end of this video I'm trying to loop through multiple pdfs in a folder and merge. I'm using DIR to identify the two specific PDFs but once it loops around the code can't seem to pick up the second group of files I need to merge. Any advice or links I can follow? Thanks very much appreciated.

[hansiman]

QUESTION:
What if you want not to insert to an existing pdf file and want to create a new file and add all the others to this new join pdf file? I tried but i think there is a problem to create an empty pdf with pdf save or s.th. else. only thing i did not try: to Create an empty pdf file for joining with an empty worksheet?

[kenstarr]

Your simplified videos really helps. Please keep it up. Thanks there!

[MrAskOnce]

Is there a version that does not include Adobe Acrobat and maybe, perhaps, Revu Bluebeam? My company did away with Adobe and replaced with Bluebeam, and now our PDF merging automation is about to get completely disrupted.

[fynderskeypers]

Hi great video thanks. Rather than inserting at a specific page, is there a way to insert a page at the last page of a document where the number of pages in that document might vary?

[chrishall]

Can a person reference a cell that contains the path for the "toDoc.Open" and the "fromDoc.Open"? Also, can a person have the "toDoc.Save" reference a cell that contains the path I want to use?

[hendrickvilla]

thank you for sharing your videos!
regarding this video i tried to copy you code, but "pdsavefull" are highlighted and not found on object library. ihave already click acrobat type 10 library on the tools reference.can you help me figure out what is the problem.
thanks in advance for answering my inquiry.

[kaiisla]

Is there a way to extract pages based off of text in the pdf? What vba method would that be?

[Tat-cxlr]

Bonjour du vert sur un fond noir n’est pas lisible. Merci

[CuriousJessy]

Hi
Can you please upload a video for
Converting multiple pdf in a folder into JPG OR PNG and save in a different folder via VBA

[basemayman]

I did not find acrobat reference at vba library, are there any way to download it

[vishnupeteti]

Is there any way to just combine all the pdf in a folder from a command in excel ?
Like loop through the folder for all pdf files and just combine them ? Doesn't matter which order ?

[danielpeach]

Thanks for the video, can you use a different PDF editor to do the same task?

[deepjoshi]

Hi thanks it’s working well
By requirement here is to extend the program like that in one excell rows I have path of the files and the macro should merge the files from rows 1 to rows n with some for loop and merge them.

[sanjayafonseka]

Hi, Thanks! My question is how split a pdf which has example 4 pages into individual one page PDFs.

[FRAN-vdrl]

hi, awesome video. how did you changed the VBA IDE to turn it black with color characters? the white IDE really burns my eyes

[mirjde]

Can we do with the list,
Lets say i have a list of PDF (200 nos) and i need to attach 3 pages in each files (These 3 pages will be different for each file)

How can we do that..

[jeganraju]

I need coding for to split the merged PDFs to certain range.