How To Read PDF Files Using Excel Macros

In This tutorial we would learn how to read the contents of PDF documents using Excel VBA Macros

[@priyanthagamini3860]

I is very useful. You explain very simply . Sir, please explain how to extract a text from a specific place in a pdf file and use it as the file name (As invoice number)

[@rameshkumarmuthusamy8574]

excellent very useful , detailed explanation of each macro line by line,

[@AutomationMadeEasy]

Glad it was helpful!

[@rickgegenheimer7556]

Amazing you are a wizard! Thank you for the instructions. How do you identify what the functions or elements are in the reference libraries?

[@user-ys7sm9yj7u]

PageNumber variable not defined, Pagecontent variable not define ! How to go about ?

[@Amitalmightyme0]

same here

[@rumim007]

IS IT POSSIBLE AN USERFORM COMMANBUTTON WILL OPEN A PDF FILE. SOME ELEMENT WILL READ THE LAST READ PAGE NUMBER AND STORE IN SHEET 1 COLUMN A. AND ANOTHER COMMANDBUTTON WILL RESUME READING FROM THE LAST READ PAGE NUMBER? EXCEL FILE WILL OPEN IN MOZILLA PDF VIEWER. IF POSSIBLE MAKE A VIDEO WITH THIS

[@3700BANDIT]

Great video @Automation made easy, 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 rd_txt.getnumtext -1” I believe I have everything the same as the video just a different folder to a pdf (obviously)

[@Sai-tek]

does this work only with pro version or will it work with readers license as well

[@AutomationMadeEasy]

Pro version

[@kavanaananth]

Can we have Adobe Acrobat Reader DC or Adobe Acrobat 2017 Professional instead of Adobe Acrobat Pro DC?

[@AutomationMadeEasy]

not sure. I have never tried

[@amritaram225]

Does the pdf need to be in readable format? Will scanned pdfs work??

[@AutomationMadeEasy]

readable

[@kklam7166]

@@AutomationMadeEasy hi, what is the VBA code if scanned PDFs ? please.

[@debu4118]

where can I get source code of this tutorial?

[@kanghusniechannel5694]

Sorry, can I have the vba code please?

[@maheshmundhra7660]

Hlo Sir, want to contact you....how is it possible.

[@AutomationMadeEasy]

write into [e-mail]

[@maheshmundhra7660]

@@AutomationMadeEasy have mailed you please check and response

[@vantrong4864]

@@maheshmundhra7660 Please give me the code bro. I would like to thank you

[@funways651]

I sent a mail on the subject automation by using excel. pls. acknowledge the mail

[@AutomationMadeEasy]

i replied