I’m trying to make automation of taking some data from PDF tables and putting it into Excel.
I would like to do one of two things, either have the name of the PDF in Column A and then all the data in one sheet or data from each PDF in a different sheet. I have made other data scraping automation where it ends in a different sheet, but that was always from a list in Excel and i don’t know what to write in the Write Range, where it’s currently “Sheet1”. FLEXFLIGHTMHL.xaml (11.9 KB)
Solving the above would be a great help, but i have a follow up question.
Some of my PDF have several data tables, but only on page 1,3,5 and so on, because there is a usage information on page 2,4,6 which isn’t relevant. Is it possible to get a data extraction from all the data tables in a pdf file?
Before hand, thank you for your help.