Do you have a video about how to set up the Acrobat API on a machine that deosn't have Acrobat DC?
@VBAA2Z
9 ай бұрын
No, I do not. However you can uninstall the reader simply install the license version
@kenstarr8612
4 жыл бұрын
Your simplified videos really helps. Please keep it up. Thanks there!
@VBAA2Z
3 жыл бұрын
you're most welcome
@hansiman9262
11 ай бұрын
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?
@VBAA2Z
11 ай бұрын
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
@hansiman9262
11 ай бұрын
You don't believe it but this is just I tried after I wrote my comment. Now I am trying to finish the steps.
@Megaawsomeberry500
3 жыл бұрын
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
@dildokafir5058
3 жыл бұрын
Dear lumpamai, What would be the object hierarchy for pdf. Like we have in PowerPoint .. ppapp then presentation then slides the txtframe n all.
@VBAA2Z
3 жыл бұрын
Check out the documentation here. vbaa2z.blogspot.com/2020/01/vba-pdf-automation-read-write-extract.html
@MrAskOnce
2 жыл бұрын
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.
@angelajimenez7746
2 жыл бұрын
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.
@VBAA2Z
2 жыл бұрын
this might help vbaa2z.blogspot.com/2016/10/vba-to-list-all-file-names-in-any.html
@chrishall691
3 жыл бұрын
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?
@CuriousJessy
2 жыл бұрын
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
@VBAA2Z
2 жыл бұрын
Sure sure
@sanjayafonseka2645
3 жыл бұрын
Hi, Thanks! My question is how split a pdf which has example 4 pages into individual one page PDFs.
@VBAA2Z
3 жыл бұрын
You're welcome. thanks for watching. Please find complete PDF automation series link below. You can delete unwanted pages and Save as new file. kzitem.info/news/bejne/1pls1pWigGlnjG0
@sanjayafonseka2645
3 жыл бұрын
Thanks! I will try that.
@fynderskeypers
3 жыл бұрын
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?
@VBAA2Z
3 жыл бұрын
try Obj.GetNumPages property.
@vishnupeteti8408
2 жыл бұрын
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 ?
@VBAA2Z
2 жыл бұрын
You can combine this function and ListFiles vbaa2z.blogspot.com/2021/04/useful-ready-to-use-vba-functions-share.html
@vishnupeteti8408
2 жыл бұрын
Thanks !
@madhurimotamarri2910
2 жыл бұрын
@@VBAA2Z Do you need a full version of Adobe to do this?
@VBAA2Z
2 жыл бұрын
@@madhurimotamarri2910 yes
@hendrickvilla
4 жыл бұрын
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.
@VBAA2Z
4 жыл бұрын
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. kzitem.info/door/PLo0aMPtFIFDqfrLJUuIkP2lrOkchJf11m
@josefcarlson679
Жыл бұрын
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?
@israeldominguez7825
10 ай бұрын
What vba Reference is used regard the matter?
@mirjde
3 жыл бұрын
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..
@VBAA2Z
3 жыл бұрын
Hi Mir, all these are covered in the tutorial. Are you stuck?
@mirjde
3 жыл бұрын
@@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
@VBAA2Z
3 жыл бұрын
@@mirjdeexcellent work there!
@jeganraju1372
4 жыл бұрын
I need coding for to split the merged PDFs to certain range.
@VBAA2Z
4 жыл бұрын
have you gone through this course. It'l give your fair idea on how to accomplish this. kzitem.info/news/bejne/1pls1pWigGlnjG0&lc=Ugyx7uJxysTSjxEyd6B4AaABAg
@kaiisla9433
4 жыл бұрын
Is there a way to extract pages based off of text in the pdf? What vba method would that be?
Bonjour du vert sur un fond noir n’est pas lisible. Merci
@VBAA2Z
3 жыл бұрын
Thanks for your feedback. Merci pour vos commentaires.
@jaymarktamacay8249
3 ай бұрын
can I combine 2 to 6 pdf file into 1?
@VBAA2Z
2 ай бұрын
yes
@VBAA2Z
2 ай бұрын
yes
@MrT-ob5ri
2 жыл бұрын
what reference did you use in VBE?
@VBAA2Z
2 жыл бұрын
Please check this link kzitem.info/news/bejne/1pls1pWigGlnjG0
@deepjoshi4387
3 жыл бұрын
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.
@VBAA2Z
3 жыл бұрын
You're most welcome!
@deepjoshi4387
3 жыл бұрын
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
@VBAA2Z
3 жыл бұрын
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
@deepjoshi4387
3 жыл бұрын
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
@deepjoshi4387
3 жыл бұрын
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
@basemayman3124
3 жыл бұрын
I did not find acrobat reference at vba library, are there any way to download it
@VBAA2Z
3 жыл бұрын
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. kzitem.info/news/bejne/1pls1pWigGlnjG0
@basemayman3124
3 жыл бұрын
@@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
@VBAA2Z
3 жыл бұрын
@@basemayman3124 no probs. please find link to download trail version here vbaa2z.blogspot.com/2020/01/vba-pdf-automation-read-write-extract.html
@danielpeach2686
4 жыл бұрын
Thanks for the video, can you use a different PDF editor to do the same task?
@VBAA2Z
4 жыл бұрын
If those editors have the API yes we can.
@dwemer2610
4 жыл бұрын
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?
@VBAA2Z
4 жыл бұрын
This is exactly what you're looking for. Re-watch the video. Here is full series on PDF Automation free from VBA A2Z. kzitem.info/news/bejne/1pls1pWigGlnjG0
@paulpaul7786
4 жыл бұрын
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?
@VBAA2Z
4 жыл бұрын
It is possible you do not have Acrobat installed. Check this link. vbaa2z.blogspot.com/2020/01/vba-pdf-automation-read-write-extract.html
@monikapatel7622
Жыл бұрын
"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
@VBAA2Z
Жыл бұрын
which office version are you?
@monikapatel7622
Жыл бұрын
@@VBAA2Z 16.0.11126.20188
@monikapatel7622
Жыл бұрын
Which office version I have to use for combine multiple pdf page?
@FRAN-vd9rl
3 жыл бұрын
hi, awesome video. how did you changed the VBA IDE to turn it black with color characters? the white IDE really burns my eyes
@VBAA2Z
3 жыл бұрын
Thanks, here's the VBE Customization tut. kzitem.info/news/bejne/rJWp0GR9e4V9mKw
@leandropura4770
3 жыл бұрын
Do i need adobe acrobats for this? Isbit possible i can merge 2 pdf using vba without acrobats?
@VBAA2Z
3 жыл бұрын
it will be difficult without Acrobat or some other 3rd party API.
@sharatcb8481
4 жыл бұрын
Hi sir, Can u help me how to merge 2 different pdfs into 1 using excel vba.
@VBAA2Z
4 жыл бұрын
Hi Sharat - take a look at these videos. kzitem.info/news/bejne/rKWK261va6eToo4 kzitem.info/news/bejne/1pls1pWigGlnjG0
@vincenzosaglimbeni1832
3 жыл бұрын
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!
@premkumarmurugesan5559
2 жыл бұрын
for me it is not working
@premkumarmurugesan5559
2 жыл бұрын
Can anyone share the coading file ?
@VBAA2Z
2 жыл бұрын
Do you have valid license?
@PradeepRai85
3 жыл бұрын
getting error "User- defined type not defined
@VBAA2Z
3 жыл бұрын
make sure you've installed acrobat
@bharathkumar.a1040
3 жыл бұрын
Could you please explain how combine more than 2 pdf documents
@VBAA2Z
3 жыл бұрын
Simply replicate the InsertPages line with desired pdf doc & page
@bharathkumar.a1040
3 жыл бұрын
@@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.
@VBAA2Z
3 жыл бұрын
Thanks Bharath. I'll add some more videos to pdf series.
@santitosrubinos8696
3 жыл бұрын
pero por qué no me sale la librería de acrobat para referenciar? que puedo hacer
@VBAA2Z
3 жыл бұрын
Sin la API de Acrobat, será difícil lograr la edición de PDF.
@vg6119
3 жыл бұрын
Also can you help in running excel macro to add a text to pdf?
@VBAA2Z
3 жыл бұрын
please check out the playlist. kzitem.info/door/PLo0aMPtFIFDqfrLJUuIkP2lrOkchJf11m
@kathiresansathishkumar884
3 жыл бұрын
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.
@VBAA2Z
3 жыл бұрын
Did you set reference to the the library? check this video for full demo kzitem.info/news/bejne/1pls1pWigGlnjG0 please check this link for more info on this error: docs.microsoft.com/en-us/office/troubleshoot/access/activex-component-cannot-create-object
@indoamericanblues
3 жыл бұрын
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
@VBAA2Z
3 жыл бұрын
Yes you should be
@indoamericanblues
3 жыл бұрын
@@VBAA2Z Thanks.. Will you be able to share a related video.
@KaiWeissmann
3 жыл бұрын
@@indoamericanblues You have to loop through the files you want to combine
@mielkew27
3 жыл бұрын
Nice video is there anyway we can loop through based on cell values
@VBAA2Z
3 жыл бұрын
Unfortunately not. If PDF was created using word doc there is possibility for table. try this video: kzitem.info/news/bejne/rKWK261va6eToo4
@mielkew27
3 жыл бұрын
@@VBAA2Z I meant combined pdf files from given file path in cell value, eg. Column A and Column B then save the file in the same folder location of Column B, then loop through to the next cell value in Column A & B. This will be very useful for drawings to combine Old Version with newer version of the drawing. Currently the filename and file path in this video is hardcoded can that be dynamically look through in cell values of Column A & B. Thanks in advance
@VBAA2Z
3 жыл бұрын
@@mielkew27 yes of course that is possible. loop through related cells without path and page numbers and combine them
@mielkew27
3 жыл бұрын
@@VBAA2Z do you have any suggestion or video tutorial how to do this? Appreciate your help.
@clientfclientl9147
3 жыл бұрын
Do you need to set everything to nothing after?
@VBAA2Z
3 жыл бұрын
yes it is good to do that.
@clientfclientl9147
3 жыл бұрын
@@VBAA2Z Do you know if you can convert a .tif file to PDF with VBA?
@VBAA2Z
3 жыл бұрын
@@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
@davejackson8592
2 жыл бұрын
I just get "No such interface supported" :(
@VBAA2Z
2 жыл бұрын
Make sure you have a Acrobat Pro or Acrobat DC vbaa2z.blogspot.com/2020/01/vba-pdf-automation-read-write-extract.html
@deepaksinha8010
3 жыл бұрын
Hi i can't see.the coding pls share
@VBAA2Z
3 жыл бұрын
To promote code yourself, projects/codes downloads are not available. Please let me know if you're stuck / need help.
@axelamoe
3 жыл бұрын
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
3 жыл бұрын
Yes that can be accomplished. Happy holidays!
@axelamoe
3 жыл бұрын
@@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
@bhawanakumari2340
4 жыл бұрын
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.
@VBAA2Z
4 жыл бұрын
You can perform this action only via PDF API (or pdf editors) so without the Acrobat license, it won't work.
@vg6119
3 жыл бұрын
Can you please share the program?
@VBAA2Z
3 жыл бұрын
HI VG, to promote code yourself, projects/codes downloads are not available. Please let me know if you're stuck / need help.
@vg6119
3 жыл бұрын
@@VBAA2Z thanks so much let me try doing it il let you know if I’m stuck
@jazibghafoor
2 жыл бұрын
How you download code
@VBAA2Z
2 жыл бұрын
please check video description
@jazibghafoor
2 жыл бұрын
@@VBAA2Z Unable to find in video description. Can you post link here
@VBAA2Z
2 жыл бұрын
please find the link vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
Пікірлер: 128