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

mattyj7183

New Member
Joined
Dec 28, 2015
Messages
12
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!
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

diddi

Well-known Member
Joined
May 20, 2004
Messages
3,267
Office Version
  1. 2010
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,127,347
Messages
5,624,136
Members
416,012
Latest member
rockermom59

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top