Тёмный

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

VBA A2Z
Подписаться 51 тыс.
Просмотров 25 тыс.
50% 1

Friendly tutorial to Automate PDF using real-world scenarios using VBA and PDF API.
More resources: vbaa2z.blogspot.com/2020/01/v...
Subscribe, Like, and Comment. 🙏Thanks for watching.
You can now support by buying any of the Projects or Source Code.
📥Downloads: pamaitech.com/downloads/
👍 Support: paypal.me/pamaitech
✉️ Contact: contact@pamaitech.com
📌What to watch next:
Playlist: ru-vid.complaylists
Videos: ru-vid.comvideos
#VbaA2z

Наука

Опубликовано:

 

15 янв 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 128   
@kenstarr8612
@kenstarr8612 4 года назад
Your simplified videos really helps. Please keep it up. Thanks there!
@VBAA2Z
@VBAA2Z 3 года назад
you're most welcome
@kiwim3p587
@kiwim3p587 11 месяцев назад
Do you have a video about how to set up the Acrobat API on a machine that deosn't have Acrobat DC?
@VBAA2Z
@VBAA2Z 7 месяцев назад
No, I do not. However you can uninstall the reader simply install the license version
@angelajimenez7746
@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
@VBAA2Z 2 года назад
this might help vbaa2z.blogspot.com/2016/10/vba-to-list-all-file-names-in-any.html
@fynderskeypers
@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
@VBAA2Z 3 года назад
try Obj.GetNumPages property.
@Megaawsomeberry500
@Megaawsomeberry500 2 года назад
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
@chrishall691
@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?
@danielpeach2686
@danielpeach2686 3 года назад
Thanks for the video, can you use a different PDF editor to do the same task?
@VBAA2Z
@VBAA2Z 3 года назад
If those editors have the API yes we can.
@dildokafir5058
@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
@VBAA2Z 3 года назад
Check out the documentation here. vbaa2z.blogspot.com/2020/01/vba-pdf-automation-read-write-extract.html
@kaiisla9433
@kaiisla9433 4 года назад
Is there a way to extract pages based off of text in the pdf? What vba method would that be?
@VBAA2Z
@VBAA2Z 4 года назад
Check video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uc6palG76Y8.html
@dwemer2610
@dwemer2610 3 года назад
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
@VBAA2Z 3 года назад
This is exactly what you're looking for. Re-watch the video. Here is full series on PDF Automation free from VBA A2Z. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uc6palG76Y8.html
@FRAN-vd9rl
@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
@VBAA2Z 3 года назад
Thanks, here's the VBE Customization tut. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-K_sj0GBSLew.html
@hendrickvilla
@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
@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. ru-vid.com/group/PLo0aMPtFIFDqfrLJUuIkP2lrOkchJf11m
@josefcarlson679
@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
@israeldominguez7825 8 месяцев назад
What vba Reference is used regard the matter?
@deepjoshi4387
@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
@VBAA2Z 3 года назад
You're most welcome!
@deepjoshi4387
@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
@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
@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
@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
@MrAskOnce
@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.
@hansiman9262
@hansiman9262 9 месяцев назад
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
@VBAA2Z 9 месяцев назад
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
@hansiman9262 9 месяцев назад
You don't believe it but this is just I tried after I wrote my comment. Now I am trying to finish the steps.
@vincenzosaglimbeni1832
@vincenzosaglimbeni1832 2 года назад
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!
@sanjayafonseka2645
@sanjayafonseka2645 3 года назад
Hi, Thanks! My question is how split a pdf which has example 4 pages into individual one page PDFs.
@VBAA2Z
@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uc6palG76Y8.html
@sanjayafonseka2645
@sanjayafonseka2645 3 года назад
Thanks! I will try that.
@vishnupeteti8408
@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
@VBAA2Z 2 года назад
You can combine this function and ListFiles vbaa2z.blogspot.com/2021/04/useful-ready-to-use-vba-functions-share.html
@vishnupeteti8408
@vishnupeteti8408 2 года назад
Thanks !
@madhurimotamarri2910
@madhurimotamarri2910 2 года назад
@@VBAA2Z Do you need a full version of Adobe to do this?
@VBAA2Z
@VBAA2Z 2 года назад
@@madhurimotamarri2910 yes
@sharatcb8481
@sharatcb8481 4 года назад
Hi sir, Can u help me how to merge 2 different pdfs into 1 using excel vba.
@VBAA2Z
@VBAA2Z 4 года назад
Hi Sharat - take a look at these videos. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KoTuy92uboY.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uc6palG76Y8.html
@leandropura4770
@leandropura4770 3 года назад
Do i need adobe acrobats for this? Isbit possible i can merge 2 pdf using vba without acrobats?
@VBAA2Z
@VBAA2Z 3 года назад
it will be difficult without Acrobat or some other 3rd party API.
@CuriousJessy
@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
@VBAA2Z 2 года назад
Sure sure
@vg6119
@vg6119 3 года назад
Also can you help in running excel macro to add a text to pdf?
@VBAA2Z
@VBAA2Z 3 года назад
please check out the playlist. ru-vid.com/group/PLo0aMPtFIFDqfrLJUuIkP2lrOkchJf11m
@MrT-ob5ri
@MrT-ob5ri Год назад
what reference did you use in VBE?
@VBAA2Z
@VBAA2Z Год назад
Please check this link ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uc6palG76Y8.html
@indoamericanblues
@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
@VBAA2Z 3 года назад
Yes you should be
@indoamericanblues
@indoamericanblues 3 года назад
@@VBAA2Z Thanks.. Will you be able to share a related video.
@KaiWeissmann
@KaiWeissmann 3 года назад
@@indoamericanblues You have to loop through the files you want to combine
@jeganraju1372
@jeganraju1372 4 года назад
I need coding for to split the merged PDFs to certain range.
@VBAA2Z
@VBAA2Z 4 года назад
have you gone through this course. It'l give your fair idea on how to accomplish this. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uc6palG76Y8.html&lc=Ugyx7uJxysTSjxEyd6B4AaABAg
@user-pm9yo6yw7i
@user-pm9yo6yw7i 4 месяца назад
it will support for kofax pdf?
@santitosrubinos8696
@santitosrubinos8696 3 года назад
pero por qué no me sale la librería de acrobat para referenciar? que puedo hacer
@VBAA2Z
@VBAA2Z 3 года назад
Sin la API de Acrobat, será difícil lograr la edición de PDF.
@paulpaul7786
@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
@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
@mirjde
@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
@VBAA2Z 3 года назад
Hi Mir, all these are covered in the tutorial. Are you stuck?
@mirjde
@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
@VBAA2Z 3 года назад
@@mirjdeexcellent work there!
@mielkew27
@mielkew27 2 года назад
Nice video is there anyway we can loop through based on cell values
@VBAA2Z
@VBAA2Z 2 года назад
Unfortunately not. If PDF was created using word doc there is possibility for table. try this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-KoTuy92uboY.html
@mielkew27
@mielkew27 2 года назад
@@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
@VBAA2Z 2 года назад
@@mielkew27 yes of course that is possible. loop through related cells without path and page numbers and combine them
@mielkew27
@mielkew27 2 года назад
@@VBAA2Z do you have any suggestion or video tutorial how to do this? Appreciate your help.
@basemayman3124
@basemayman3124 3 года назад
I did not find acrobat reference at vba library, are there any way to download it
@VBAA2Z
@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uc6palG76Y8.html
@basemayman3124
@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
@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
@axelamoe
@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
@VBAA2Z 3 года назад
Yes that can be accomplished. Happy holidays!
@axelamoe
@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
@Tat-cx1lr
@Tat-cx1lr 3 года назад
Bonjour du vert sur un fond noir n’est pas lisible. Merci
@VBAA2Z
@VBAA2Z 3 года назад
Thanks for your feedback. Merci pour vos commentaires.
@kathiresansathishkumar884
@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
@VBAA2Z 3 года назад
Did you set reference to the the library? check this video for full demo ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uc6palG76Y8.html please check this link for more info on this error: docs.microsoft.com/en-us/office/troubleshoot/access/activex-component-cannot-create-object
@jaymarktamacay8249
@jaymarktamacay8249 Месяц назад
can I combine 2 to 6 pdf file into 1?
@VBAA2Z
@VBAA2Z 28 дней назад
yes
@VBAA2Z
@VBAA2Z 28 дней назад
yes
@bharathkumar.a1040
@bharathkumar.a1040 3 года назад
Could you please explain how combine more than 2 pdf documents
@VBAA2Z
@VBAA2Z 3 года назад
Simply replicate the InsertPages line with desired pdf doc & page
@bharathkumar.a1040
@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
@VBAA2Z 3 года назад
Thanks Bharath. I'll add some more videos to pdf series.
@clientfclientl9147
@clientfclientl9147 3 года назад
Do you need to set everything to nothing after?
@VBAA2Z
@VBAA2Z 3 года назад
yes it is good to do that.
@clientfclientl9147
@clientfclientl9147 3 года назад
@@VBAA2Z Do you know if you can convert a .tif file to PDF with VBA?
@VBAA2Z
@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
@PradeepRai85
@PradeepRai85 3 года назад
getting error "User- defined type not defined
@VBAA2Z
@VBAA2Z 3 года назад
make sure you've installed acrobat
@deepaksinha8010
@deepaksinha8010 3 года назад
Hi i can't see.the coding pls share
@VBAA2Z
@VBAA2Z 3 года назад
To promote code yourself, projects/codes downloads are not available. Please let me know if you're stuck / need help.
@monikapatel7622
@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
@VBAA2Z Год назад
which office version are you?
@monikapatel7622
@monikapatel7622 Год назад
@@VBAA2Z 16.0.11126.20188
@monikapatel7622
@monikapatel7622 Год назад
Which office version I have to use for combine multiple pdf page?
@bhawanakumari2340
@bhawanakumari2340 3 года назад
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
@VBAA2Z 3 года назад
You can perform this action only via PDF API (or pdf editors) so without the Acrobat license, it won't work.
@davejackson8592
@davejackson8592 2 года назад
I just get "No such interface supported" :(
@VBAA2Z
@VBAA2Z 2 года назад
Make sure you have a Acrobat Pro or Acrobat DC vbaa2z.blogspot.com/2020/01/vba-pdf-automation-read-write-extract.html
@premkumarmurugesan5559
@premkumarmurugesan5559 2 года назад
for me it is not working
@premkumarmurugesan5559
@premkumarmurugesan5559 2 года назад
Can anyone share the coading file ?
@VBAA2Z
@VBAA2Z 2 года назад
Do you have valid license?
@vg6119
@vg6119 3 года назад
Can you please share the program?
@VBAA2Z
@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
@vg6119 3 года назад
@@VBAA2Z thanks so much let me try doing it il let you know if I’m stuck
@jazibghafoor
@jazibghafoor 2 года назад
How you download code
@VBAA2Z
@VBAA2Z 2 года назад
please check video description
@jazibghafoor
@jazibghafoor 2 года назад
@@VBAA2Z Unable to find in video description. Can you post link here
@VBAA2Z
@VBAA2Z 2 года назад
please find the link vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
Далее
VBA to delete PDF Pages - VBA PDF Automation-8
3:39
Просмотров 2,6 тыс.
VBA to fill out PDF Forms - VBA PDF Automation-6
13:29
ТОП 10 Худших игроков Евро-2024
30:22
Good dad 🥰 #demariki
00:17
Просмотров 10 млн
How To Read PDF Files Using Excel Macros
14:36
Просмотров 17 тыс.
Собери ПК и Получи 10,000₽
1:00
Просмотров 2,4 млн