May 04 2023 03:47 AM
I am having a excel file in which I want to extract data from a PDF files and want that spreadsheet to get updated whenever a new file is saved in PDF file folder.
So, my main concern is that I am having a macro enabled excel file with which we makes invoice and after printing invoice it gets saved as PDF. Now I want data of that PDF files get entered into the excel spreadsheet automatically.
I am attaching link of excel file I hope somebody will help.
May 04 2023 06:15 AM
Perhaps Power Query works, but it depends on which Excel platform/version you are and how PDF files are structured.