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?
Help needed in VBA
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
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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.
Be as you wish to seem
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.Originally Posted by jecali
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Posting Permissions
Reply With Quote
