Extracting Specific Fields from multiple PDFs with VBA (Excel 2019)

chickyguy

New Member
Joined
Mar 27, 2024
Messages
17
Office Version
  1. 2019
Platform
  1. Windows
Hi All,

I been given a folder with a list of PDFs and I need to extract certain fields out of it to an excel sheet.
However, we are only capable of using Excel 2019, so Power Query was out of the window.

I'm currently attempting VBA to solve this problem. However, I'm not well-versed at all so I don't even know if a solution is possible.
Currently I'm able to read the PDFs by converting it to a Word document as per a thread on this forum previously, and am in the process of attempting to extract only specific fields from it.

Due to sensitivity of the PDFs, I'm unable to upload a sample.
However, I have done up a sample structure of the PDFs:

1711551283844.png

Between Information Uno and Cinco, there are 3 other tables that can be ignored.

My needed output is this:

1711551353801.png


The caveat is that the fields names from PDFs might vary across each other, so FieldA might be AField in another document... but the position of the data within the table is the same.

Any advice is welcome and thoroughly appreciated - even if it's just advice saying its not viable.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Apologies for the double comment, but I made a mistake. Field names may differ, and so do positions.

there might be a FieldC and FieldCA, pushing down FieldD further in the table.
 
Upvote 0

Forum statistics

Threads
1,216,503
Messages
6,131,020
Members
449,615
Latest member
Nic0la

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
Back
Top