VBA to read contents from PDF File - VBA PDF Automation-3
HTML-код
- Опубликовано: 12 янв 2025
- Friendly tutorial to Automate PDF using real-world scenarios using VBA and PDF API.
More resources: vbaa2z.blogspo...
Subscribe, Like, and Comment. 🙏Thanks for watching.
You can now support by buying any of the Projects or Source Code.
📥Downloads: pamaitech.com/...
👍 Support: paypal.me/pama...
✉️ Contact: contact@pamaitech.com
📌What to watch next:
Playlist: www.youtube.co...
Videos: www.youtube.co...
#VbaA2z
Thank you so much for the very detailed explanation, this is much much more clear then the VBA courses I took years ago! Thank you so much for sharing this knowledge. Bless you!
This is SO cool. Thank you for taking the time to make this tutorial.
You are so welcome!
This was SO helpful, thank you very much! Is there a way to detect if the text is underlined or bold in the PDF as you are reading through it?
Wow, your works are amazing. Thank you.
Thank you very much!
Wow! This amazing. Thanks to you Sir
You are most welcome
Nice tutorial man, literaly saved me
Glad it helped!
Excellent video. Could you please show us to only extract comments and annotations from the pdf file.
Sure, thanks for suggestion. I'll do more videos on PDF automation.
Thanks for such a detailed and easy walkthrough. I was looking for something similar to automate a US tax form. I would like to update this form filed using values from different cells in Excel. One way I can think to do this using sheet.range function along with for to loop in all the rows for to update all data. Am I right, or are there any other suggestions?
Glad it was helpful!
Take a look at this video. ruclips.net/video/v-uxpc86wrw/видео.html
Thanks for the response. I did see this is video yesterday, but from what I see, the you did fill out the pdf but the values were constant and update in vba window. As I would like to update it for multiple companies I need it to be more dynamic. So that I could take values from excel cell.
Sorry for multiple comments, but one last question. I tried to use your code but unfortunately I am not able to open the pdf form . I am getting access denied pop up
Hello. Thanks for the tutorial!
Do you know if is it possible to get the coordinates of each word?
well it depends
Can it be used with files scanned onto a PC? It's similar to the picture but in a pdf.
I don't have the acrobat 10 tape library in excel. you know a way for me to do the dowlonad. thank you !!!
I'll show another way to read without Acrobat or Adobe reader. Do not forget to subscribe for upcoming videos.
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
Yes sure
Nice one!
Thank you! Cheers!
Great video,
can someone help me? I’m getting a “Runtime error 91: object variable or with block variable not set” on line “For j = 0 to sel_text.getnumtext -1” I believe I have everything the same as the video just a different folder to a pdf (obviously)
I understand extraction of PDF text to Excel.
How to extract only comments from PDF to Excel. Instead of manually from PDF acrobat, can I automate it using VBA?
If you have a solution for this, could you please share. Thanks
Thanks for the code I run it but getting single single charecters in immediate window.
How can I get exact words only ?
How to get values next to perticular word?
Hi I got "ActiveX component can't create object". why is that?
Have you installed, adobe acrobat? If not, please find the link to download free trial version in the video description.
@@VBAA2Z Team I am using Adobe acrobat DC pro but getting same error (Reference selected as Adobe Acrobat library) Kindly help to solve this
Can you please link me to the video to format the text like the PDF?
not sure if there is a way to read properties.
Great. Can we read data from one pdf form nd fill the same in another pdf form ? Or can we copy data from Excel sheet and paste it in PDF form ?
Yes, you can. Please check this video.
ruclips.net/video/uc6palG76Y8/видео.html
I get a runtime error "no such interface supported" for Set aApp = CreateObject("AcroExch.App") and set av_doc = CreateObject("AcroExch.AVDoc") any ideas? I have the correct reference checked Adobe Acrobat 10.0 Type Library. Thanks.
Me to same problem, someone help us?
@@sametcimen3767 I guess Adobe Acrobat Pro is needed, the Reader does not support this. Thanks, greedy Adobe!
Even i got the same error
Great one!!!! i tried this but if we have a = symbol in pdf then it is not running
feel free to share your code (email in vid desc.) i can check it for you
acrobat reader is fine or need editor version to run the code
Hi Vijay, you'll need Acrobat Professional. Check below link for more info
vbaa2z.blogspot.com/2020/01/vba-pdf-automation-read-write-extract.html
i get 462 error while running the code in line " Set pdf_doc = av_doc.GetPDDoc"
Hi Vijay, you'll need Acrobat Professional. Check below link for more info
vbaa2z.blogspot.com/2020/01/vba-pdf-automation-read-write-extract.html
hi, this does not seems to work with Adobe Acrobat DC Reader. Can someone please confirm? I was not able to see the AcroApp when I declare "Dim aApp as Acrobat.???", the only option is cAcroApp.. Thanks!
Hi Dan, this won't work on reader license, it needs pro
That’s sad, any other solution for non pro members..¿
Hi - will this not work without Adobe professional?
Pls help out
yes, check this option if you do not have a license.
ruclips.net/video/KoTuy92uboY/видео.html
Awesome
thanks
Hi sir
I am not finding the Acrobat library in Tools>>Reference>
Could you please help for this
please check this link for more info.
vbaa2z.blogspot.com/2020/01/vba-pdf-automation-read-write-extract.html
How to print horizontal
Hi, as soon as I get to setting the aApp, my excel crashes.
please try re-installing Acrobat.
delete temp files and try again
Nice but data are not arranged so that i can identify.Thank You
Ok. Thanks
It is not working with Acrobat reader
Acrobat pro is needed
How can I search for text in all pages?
You can read text from each page and may be compare using Instr
ruclips.net/video/uc6palG76Y8/видео.html
use exact code like you...but constant showing error
Try update file link. Maybe file path was not correct.
Again a great tutorial.
can you please change this line
Debug.Print sel_text.GetText(j)
to
Debug.Print sel_text.GetText(j);
and then look what this will do. This is great for me!
I am trying to get it printed like this in an Excel file.
Can you help out?
Because I don't know if it is possible to read data from PDF line by line.
It is ok, if the complete TXT will be put into Cell A1, I will then use Excel to rebuild data into columns etc ( the same way I would do when importing a TXT file)
will it also work for scanned PDF files?
nope, you can try googling OCR APIs.
@@VBAA2Z thanks.if you know of good free OCR API suggest please
@@vineetgupta1064 I have not tried it myself so I have no recommendations for VBA
I could not find the code from any of the links..anyone has code please?
To promote code yourself, projects/codes downloads are not available. Please let me know if you're stuck / need help.
👏👏👏
thanks!
i can show you image
Yes you can add image to Form using Forms Central / Acrobat.