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

Clarissa Röthig 0 Reputation points
2023-07-21T08:31:04.9633333+00:00

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 :)

Transferprocess

PDF Mockup.pdf

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,324 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Sachin Molke 0 Reputation points
    2023-12-17T06:48:43.3033333+00:00
    0 comments No comments