VBA Code to transfer PDF Data to Excel and automaticly transfer the needed data to needed fields

Question

Hello Everyone,

I need assistance with my Excel worksheet where I am importing data from a PDF file. I'm utilizing the "Data > Get Data > From File > From PDF" feature to convert standardized PDFs into structured tables. When importing the data, I always select the "Page001" option. You can find a sample of these PDFs attached. I have also attached a .gif demonstrating my current manual process.

My goal is to automate this process with a Macro or VBA code that I can attach to a push button. Once the PDF is selected and the table generated, I need certain values from this table to be automatically transferred/copied into predefined cells on a different worksheet.

Can anyone guide me on how to set up this automation or provide some example VBA code to help me get started? Any help is appreciated.

Best Regards,

Duza :)

PDF Mockup.pdf

Answer 1

Change-Control-Form-1-2.pdf