Extracting text from PDF Files into Excel.

[Saee Mane]

Hello All,

Is there any VBA code to extract text from PDF file into an Excel.

Here my requirement is after downloading the PDF files the VBA code should extract the specific data from it in excel sheet.

Your assistance will be highly appreciated. Thank you in advance.

 

[rjmdc]

specifically with VBA?
i do this all the time with power query
i do get data from PDF

 

[Dan_W]

There is VBA code that will extract text from a PDF file. If you follow one of the related links at the bottom of this page - Extract data from .PDF - the response by GWteB leverages the PDF reader functionality in MS Word, and outputs the text to a spreadsheet.

From there, it should be straightforward to adapt it to your particular needs.

 

[Saee Mane]

There is VBA code that will extract text from a PDF file. If you follow one of the related links at the bottom of this page - Extract data from .PDF - the response by GWteB leverages the PDF reader functionality in MS Word, and outputs the text to a spreadsheet.

From there, it should be straightforward to adapt it to your particular needs.

It is Amazing!
Thank you so much for the code.

I tried the code and it is working exactly the way I want.

 

[Dan_W]

That's great - glad to hear it. More importantly, thanks to @GWteB for writing the code!