Hello guys,
I'm a bginner in VBA.
My Q is how can I use macro to get data from PDF files and put them in excel?
Printable View
Hello guys,
I'm a bginner in VBA.
My Q is how can I use macro to get data from PDF files and put them in excel?
If you are using Office 365, you can do this with Excel's built in tool.
Go to the Data Tab, Select Get Data/From File/From PDF. This will allow you to import data from a selected file
Thank you Aussiebear but what about if I want only a certain data no the whole pdf.
You don't have to import all the data.
if it's a structured recurring data of pdf files, you can import it into excel, then record a macro of you cleaning the data set as you want
then after that each pdf file you can run the macro again and it will be in the similar format you want it
Why re-invent the wheel? Excel already provides the necessary tools to do this.Quote:
Originally Posted by jecali