Friendly tutorial to Automate PDF using real-world scenarios using VBA and PDF API.
More resources:
Subscribe, Like, and Comment. 🙏Thanks for watching.
You can now support by buying any of the Projects or Source Code.
📥Downloads:
👍 Support:
✉️ Contact: vbaa2z.team@gmail.com
📌What to watch next:
Playlist:
Videos:
#VbaA2z…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
great videos, it helping me alot.Thank you so much
Having an issue – with setting the application (application) as Acrobat. acrobat is not in the list.
I have and use it daily. Can see the path and that its is running on my operating system. the error I receive is compile error User-defined type not defined" is there another way to specify the application.
And
how to a loop this to combine 6 files, just adding each to the end/after last page/ of the prior.
This will save a ton of time if I can get it to work.
Thank you for the detail on how to complete this.
Great video, really helped me out! I am using the read pdf form VBA. Is there an easy way to put the values into columns instead of rows?
Tks for sharing! Great Video… just one question… Is it possible to do something like this using just the Adobe Acrobat Reader? Or is mandatory to purchase the Adobe Acrobat Standard / Pro Edition?
The "Read from PDF" code failed with "No such interface supported" at "Set aApp = CreateObject("AcroExch.App")". I googled this and found this problem reported a number of times but with no fix that worked for me. Does it still work for you?
Your video "VBA to read values in PDF Form without Reader or Acrobat API – VBA PDF Automation-12" did work for me. Thanks for your work on this.
in my tools >refrencese ı cant fınd adobe acrobat10,0 type library
Great video, please explain how to rename PDF files in a folder on the content of PDF files as Invoice number, ID No. etc.. the items (invoice no. etc.. ) are same location in pdf files
I need this badly, sending order your way. Thank you my friend!
Any way to combine multiple pdf without acrobat? Thanks for this detailed and useful series.
55:00 Convert PDF to Word, Excel, HTML
1:01:23 Extract PDF table Power Query + VBA
I have been trying to find out what VBA code is needed to extract all pages from a PDF file and save as separate PDF's. I altready have VBA (Excel) code to remame the exracted PDF's, but if I could extract using VBA, then this would further streamline the workflow. Could not find anything workable on Web?
Great video and very helpful. Thanks. Is there a way to have a VBA to attach different type of document such as word,excel, etc. to the pdf instead of print to pdf and combine them?
I'm involved in documentation and I'm looking for a way to merge certain files listed in an Excel document. I have made a complex spreadsheet that based of document name and unique ID number i can filter the files needed to merge however trying Power Automate Desktop it can't process the files simply based on their location. I still need to try an IF statement if I can parse the files need to merge based on their unique #ID number e.e. (#3234). So I have a local directory synced with OneDrive that contains 2000+ PDF files and I want to use Excel to drive a VBA to merger files in each row in Excel and loop ForEach line of data to merge hundreds of PDF files. Can this solution help do this?
Thank you so much for useful videos
Thanxx
Hi I am getting error on createobject(“AcroExch.app”)
Active x components cannot create objects plz reply anyone
I Entered all of the code exactly as you did and I am getting an error code. Run-Time error '1004': Application-defined or object-defined error. After digging into it a while, I found that when the code is getting the text, if it runs into an equal sign "=" this is when it fails. My form has several "=" equal signs so during the investigation I took out the first instance of the ='s and ran the code again and it failed at the second instance of an = sign. so I know it is the ='s how can I bypass the equal sign, without removing them all from the document first? Thanks
Is there a way to do this without Adobe? the team using the software will not all have that installed, just office/excel.
I'm getting a security issue when doing 'jso_obj.SaveAs dfile, "com.adobe.acrobat." & ext'.. i have Adobe Acrobat Pro DC licence still getting security access warning. Doesnt look like you ran into this issue though, any advice?
Hello, if I get this error message:
Run time error : "-2147319322 (800280rb)';
"Automation Error, Element no found"
And pdf_form_fld 's value is nothing
What are the possible causes?
Thank you
Great job,
I was wondering if this can be done in ACCESS. I can make pdf reports from Access report or a form but can do the same with PowerPoint.
thank you so much sirji
thank you so much sir