Scrape Values from PDFs - VBA or Power Query or Something Else

[mattyj7183]

Hello-

I have a folder with 25 different PDFs that have values of different investments. The PDFs can be grouped into 4 different layouts, meaning 10 are organized the same way but with information specific to that PDF, 9 others organized the same way but with info specific to that PDF, and so on and so forth.

Each PDF has a specific datapoint I am trying to scrape and use to populate a summary excel sheet that would show the value of each of the 25 investments. To add to the complexity, I have to design the summary sheet to be able to reference all the PDFs as needed so I can easily update the summary values when new PDFs are added to the folder.

I've tried exporting the PDFs to Excel in Adobe, but that doesn't seem easily repeatable/efficient since I have 25 PDFs. I also tried Power Query, but I am still learning it so I don't think I was going in the right direction.

Do you suggest VBA, PQ, or something else to automate this?

Thanks in advance!

 

[diddi]

i found a free program call PDF2Text Pilot. it is free. i use it for ripping prices and part numbers out of invoices to update my own inventory program. you get consistant results which you can parse with text functions in VBA