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.
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?
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
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?
Certainly, you can create a placeholder page with a message like this: "This is a placeholder page. Please check back soon for the completed content." Once you've added the required pages and content, you can remove or replace this placeholder page as needed
do you believe i could use parts of this code to create a new pdf doc with specific pages from other pdf doc? For example, pdfdoc1 has 100 pages and a want to create pdfdoc2 with the pages 25-30 from the pdfdoc1. Do you believe it's possible?
This is exactly what you're looking for. Re-watch the video. Here is full series on PDF Automation free from VBA A2Z. ua-cam.com/video/uc6palG76Y8/v-deo.html
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.
Hi Enrique, that is not expected when you have referenced the (Adobe Acrobat xx.xx Type Library) library. Have you tried other codes methods from this playlist? I can take a look at your code, please feel free to email (in the video description) me. ua-cam.com/play/PLo0aMPtFIFDqfrLJUuIkP2lrOkchJf11m.html
I have the same issue. I have referenced the Adobe Acrobat xx.xx Type Library but I the user defined typoe is not defined. What might cause this issue?
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.
You're welcome. thanks for watching. Please find complete PDF automation series link below. You can delete unwanted pages and Save as new file. ua-cam.com/video/uc6palG76Y8/v-deo.html
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 ?
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.
Can you please help me for that code Row1 one file path is there Row2 one file path is there Row3 one file path is there Row n one file path is there I need that on one macro it merge all files one By one
Easiest way would be to convert it to function that way you can loop through all files paths in range and execute the function. do not forget to subscribe for new videos
Hi definitely I will subscribe it as I am new on this and now we’ll versed into functions ans all Can you please send me code for same and will great the full to you
Hi definitely I will subscribe it as I am new on this and now we’ll versed into functions ans all Can you please send me code for same and will great the full to you
Good evening Sir, first I will start with my sincerest compliments. I learned a lot from you videos, which you basically provide for free. Thanks a lot! I have a request: Have you a video, which show me the solution to my current problem. I have an excel worksheet with a numbel, lets say 00001 to 00100. My program has to be able to go through those numbers, extract the specific documents, that are located on different paths, merge them to one, and safe them into a specific folder. To be clear: Number 000001 has 3 different documents in 3 different pathes, and those documents have to merge in one document in a specific order, in my folder on my desktop. I hope I was clear what I need and I hope you can help me in this matter. Thank you in advantages!
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?
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..
Hi Sara, thanks for visiting. Please find the complete video link with introduction about the course. In this below video description you'll find more info about additional resources. ua-cam.com/video/uc6palG76Y8/v-deo.html
@@VBAA2Z thank you for you reply, but what am mean when I build the code (dim as Aaap acrobat.acroapp) the code not appeared, when I searched in web they said I should download acrobat library to can build the code. can you please advice me
Hye, it do not works for me. The line « Set Aapp= creatObject(« AcroExch.App ») do not works and display: an Active X component cannot create an object. Can you help me please?
have you gone through this course. It'l give your fair idea on how to accomplish this. ua-cam.com/video/uc6palG76Y8/v-deo.html&lc=Ugyx7uJxysTSjxEyd6B4AaABAg
@@VBAA2Z Thank you for your response, I will try and let you know the outcome, it would be really great if you can make a short video of merging all the pdf documents using the loop, that can be second part of this video. I found this query most searched VBA one in internet and unfortunately the available coding details are not clear and understandable.once again thank you for your videos and making our life easier.Hope to see you million subscribers category very soon and all the best.
Hello, Great video as always. I was wondering is there anyway you can have a statement made from excising excel file, then combine it with all pdfs in a certain folder? I have also emailed you about a request. Thank you again and happy holidays.
@@VBAA2Z Thank you anyway I can contact you and see how I can get this done? I emailed you from an aol email. I have dynamic tables in the pdf sheets I receive. I am interested in seeing how this can be accomplished. Thank you
this video is very useful for me. Please support i have received ActiveX component can't create object error. I have installed Adope Acrobat 8.0 Library.
Did you set reference to the the library? check this video for full demo ua-cam.com/video/uc6palG76Y8/v-deo.html please check this link for more info on this error: docs.microsoft.com/en-us/office/troubleshoot/access/activex-component-cannot-create-object
@@clientfclientl9147 try conversion functions shown in the video and let me know how it goes. I have not tried it myself. here are links by topics vbaa2z.blogspot.com/2020/01/vba-pdf-automation-read-write-extract.html
"Run-time error '-2146959355 (80080005)': No such interface supported." I face this error when I try to create pdf.. can you please help me how can I resolve it
Hi I do have adobe acrobat DC installed in my system but when I run this code I get error "ActiveX Component cant create object" for toDoc. Please help me in that.
Your simplified videos really helps. Please keep it up. Thanks there!
you're most welcome
Do you have a video about how to set up the Acrobat API on a machine that deosn't have Acrobat DC?
No, I do not. However you can uninstall the reader simply install the license version
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.
this might help vbaa2z.blogspot.com/2016/10/vba-to-list-all-file-names-in-any.html
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?
try Obj.GetNumPages property.
hi, awesome video. how did you changed the VBA IDE to turn it black with color characters? the white IDE really burns my eyes
Thanks, here's the VBE Customization tut.
ua-cam.com/video/K_sj0GBSLew/v-deo.html
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
Thanks for the video, can you use a different PDF editor to do the same task?
If those editors have the API yes we can.
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?
Certainly, you can create a placeholder page with a message like this:
"This is a placeholder page. Please check back soon for the completed content."
Once you've added the required pages and content, you can remove or replace this placeholder page as needed
You don't believe it but this is just I tried after I wrote my comment.
Now I am trying to finish the steps.
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
Sure sure
Is there a way to extract pages based off of text in the pdf? What vba method would that be?
Check video: ua-cam.com/video/uc6palG76Y8/v-deo.html
do you believe i could use parts of this code to create a new pdf doc with specific pages from other pdf doc? For example, pdfdoc1 has 100 pages and a want to create pdfdoc2 with the pages 25-30 from the pdfdoc1. Do you believe it's possible?
This is exactly what you're looking for. Re-watch the video.
Here is full series on PDF Automation free from VBA A2Z. ua-cam.com/video/uc6palG76Y8/v-deo.html
it will support for kofax pdf?
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.
Hi Enrique, that is not expected when you have referenced the (Adobe Acrobat xx.xx Type Library) library. Have you tried other codes methods from this playlist? I can take a look at your code, please feel free to email (in the video description) me.
ua-cam.com/play/PLo0aMPtFIFDqfrLJUuIkP2lrOkchJf11m.html
I have the same issue. I have referenced the Adobe Acrobat xx.xx Type Library but I the user defined typoe is not defined. What might cause this issue?
What vba Reference is used regard the matter?
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.
Hi, Thanks! My question is how split a pdf which has example 4 pages into individual one page PDFs.
You're welcome. thanks for watching.
Please find complete PDF automation series link below. You can delete unwanted pages and Save as new file.
ua-cam.com/video/uc6palG76Y8/v-deo.html
Thanks! I will try that.
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 ?
You can combine this function and ListFiles
vbaa2z.blogspot.com/2021/04/useful-ready-to-use-vba-functions-share.html
Thanks !
@@VBAA2Z Do you need a full version of Adobe to do this?
@@madhurimotamarri2910 yes
what reference did you use in VBE?
Please check this link ua-cam.com/video/uc6palG76Y8/v-deo.html
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.
You're most welcome!
Can you please help me for that code
Row1 one file path is there
Row2 one file path is there
Row3 one file path is there
Row n one file path is there
I need that on one macro it merge all files one By one
Easiest way would be to convert it to function that way you can loop through all files paths in range and execute the function.
do not forget to subscribe for new videos
Hi definitely I will subscribe it as I am new on this and now we’ll versed into functions ans all
Can you please send me code for same and will great the full to you
Hi definitely I will subscribe it as I am new on this and now we’ll versed into functions ans all
Can you please send me code for same and will great the full to you
Good evening Sir, first I will start with my sincerest compliments. I learned a lot from you videos, which you basically provide for free. Thanks a lot! I have a request: Have you a video, which show me the solution to my current problem. I have an excel worksheet with a numbel, lets say 00001 to 00100. My program has to be able to go through those numbers, extract the specific documents, that are located on different paths, merge them to one, and safe them into a specific folder. To be clear: Number 000001 has 3 different documents in 3 different pathes, and those documents have to merge in one document in a specific order, in my folder on my desktop. I hope I was clear what I need and I hope you can help me in this matter. Thank you in advantages!
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?
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..
Hi Mir, all these are covered in the tutorial. Are you stuck?
@@VBAA2Z
Thanks Brother..
I figure it out...
It took less than a minute to finish 200 Files whish normally took me 3-4 days...
Thanks Again
@@mirjdeexcellent work there!
Do i need adobe acrobats for this? Isbit possible i can merge 2 pdf using vba without acrobats?
it will be difficult without Acrobat or some other 3rd party API.
can I combine 2 to 6 pdf file into 1?
yes
yes
Hi.. great video, can we combine similar file name files to one eg 1A, 1B, 1c to 1 and 2A,2B, 2c to 2 .... and so on
Yes you should be
@@VBAA2Z Thanks.. Will you be able to share a related video.
@@indoamericanblues You have to loop through the files you want to combine
I did not find acrobat reference at vba library, are there any way to download it
Hi Sara, thanks for visiting.
Please find the complete video link with introduction about the course.
In this below video description you'll find more info about additional resources. ua-cam.com/video/uc6palG76Y8/v-deo.html
@@VBAA2Z thank you for you reply, but what am mean when I build the code (dim as Aaap acrobat.acroapp) the code not appeared, when I searched in web they said I should download acrobat library to can build the code.
can you please advice me
@@basemayman3124 no probs.
please find link to download trail version here vbaa2z.blogspot.com/2020/01/vba-pdf-automation-read-write-extract.html
Hi sir,
Can u help me how to merge 2 different pdfs into 1 using excel vba.
Hi Sharat - take a look at these videos.
ua-cam.com/video/KoTuy92uboY/v-deo.html
ua-cam.com/video/uc6palG76Y8/v-deo.html
Hye, it do not works for me. The line « Set Aapp= creatObject(« AcroExch.App ») do not works and display: an Active X component cannot create an object. Can you help me please?
It is possible you do not have Acrobat installed. Check this link.
vbaa2z.blogspot.com/2020/01/vba-pdf-automation-read-write-extract.html
Also can you help in running excel macro to add a text to pdf?
please check out the playlist.
ua-cam.com/play/PLo0aMPtFIFDqfrLJUuIkP2lrOkchJf11m.html
I need coding for to split the merged PDFs to certain range.
have you gone through this course. It'l give your fair idea on how to accomplish this.
ua-cam.com/video/uc6palG76Y8/v-deo.html&lc=Ugyx7uJxysTSjxEyd6B4AaABAg
Bonjour du vert sur un fond noir n’est pas lisible. Merci
Thanks for your feedback.
Merci pour vos commentaires.
Could you please explain how combine more than 2 pdf documents
Simply replicate the InsertPages line with desired pdf doc & page
@@VBAA2Z Thank you for your response, I will try and let you know the outcome, it would be really great if you can make a short video of merging all the pdf documents using the loop, that can be second part of this video. I found this query most searched VBA one in internet and unfortunately the available coding details are not clear and understandable.once again thank you for your videos and making our life easier.Hope to see you million subscribers category very soon and all the best.
Thanks Bharath. I'll add some more videos to pdf series.
Hello, Great video as always. I was wondering is there anyway you can have a statement made from excising excel file, then combine it with all pdfs in a certain folder? I have also emailed you about a request. Thank you again and happy holidays.
Yes that can be accomplished.
Happy holidays!
@@VBAA2Z Thank you anyway I can contact you and see how I can get this done? I emailed you from an aol email. I have dynamic tables in the pdf sheets I receive. I am interested in seeing how this can be accomplished. Thank you
this video is very useful for me. Please support i have received ActiveX component can't create object error. I have installed Adope Acrobat 8.0 Library.
Did you set reference to the the library? check this video for full demo ua-cam.com/video/uc6palG76Y8/v-deo.html
please check this link for more info on this error: docs.microsoft.com/en-us/office/troubleshoot/access/activex-component-cannot-create-object
Do you need to set everything to nothing after?
yes it is good to do that.
@@VBAA2Z Do you know if you can convert a .tif file to PDF with VBA?
@@clientfclientl9147 try conversion functions shown in the video and let me know how it goes. I have not tried it myself.
here are links by topics
vbaa2z.blogspot.com/2020/01/vba-pdf-automation-read-write-extract.html
"Run-time error '-2146959355 (80080005)': No such interface supported." I face this error when I try to create pdf.. can you please help me how can I resolve it
which office version are you?
@@VBAA2Z 16.0.11126.20188
Which office version I have to use for combine multiple pdf page?
getting error "User- defined type not defined
make sure you've installed acrobat
pero por qué no me sale la librería de acrobat para referenciar? que puedo hacer
Sin la API de Acrobat, será difícil lograr la edición de PDF.
for me it is not working
Can anyone share the coading file ?
Do you have valid license?
I just get "No such interface supported" :(
Make sure you have a Acrobat Pro or Acrobat DC
vbaa2z.blogspot.com/2020/01/vba-pdf-automation-read-write-extract.html
Hi i can't see.the coding pls share
To promote code yourself, projects/codes downloads are not available. Please let me know if you're stuck / need help.
Can you please share the program?
HI VG, to promote code yourself, projects/codes downloads are not available. Please let me know if you're stuck / need help.
@@VBAA2Z thanks so much let me try doing it il let you know if I’m stuck
Hi I do have adobe acrobat DC installed in my system but when I run this code I get error "ActiveX Component cant create object" for toDoc. Please help me in that.
You can perform this action only via PDF API (or pdf editors) so without the Acrobat license, it won't work.
How you download code
please check video description
@@VBAA2Z Unable to find in video description. Can you post link here
please find the link vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html