I would like to ask Do we have the codes to open a bunch of PDF files and copy the data in those files into worksheet?
Thank you.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Extract data from PDF file into Excel
0
Discussion
Hi Tam,
You haven't provided enough information to be able to provide an answer/solution. To be able to do what you ask, the file path to the folder with the pdf's is needed and the pdf file names are needed. What data in the pdf do you want to copy and where in the Excel file do you want to copy the data to (one worksheet or multiple worksheets)?
Provide us with more details and we should be able to help.
If you want to try to figure it out by yourself try this link:
Get PDF Data
Cheers :-)
You haven't provided enough information to be able to provide an answer/solution. To be able to do what you ask, the file path to the folder with the pdf's is needed and the pdf file names are needed. What data in the pdf do you want to copy and where in the Excel file do you want to copy the data to (one worksheet or multiple worksheets)?
Provide us with more details and we should be able to help.
If you want to try to figure it out by yourself try this link:
Get PDF Data
Cheers :-)
WillieD24 (rep: 687) Jul 19, '24 at 2:25 pm
I didn't include the rest of the code because the codes that send data to destination along with the codes that clear the form work perfectly.
I know my problem is in that one line. I can add the whole code Monday if people think it's totally necessary.
Thank you
I know my problem is in that one line. I can add the whole code Monday if people think it's totally necessary.
Thank you
Galanthias (rep: 4) Jul 19, '24 at 2:57 pm
@Willie - your link above doesn't actually include a URL at present.
John_Ru (rep: 6722) Jul 19, '24 at 4:08 pm
@Galanthias - you posted the response above (to your own question) under this (another) question thread
John_Ru (rep: 6722) Jul 19, '24 at 4:18 pm
@John
I tried to insert a link to "VBA Macro To Open A PDF File - My Engineering World" but couldn't get it to work. I have used the "Add Link" function in the past with no problems. I just realized that the URL I pasted in was lacking "https://" - I have corrected it. I remembered that I first need to copy and paste the URL into Word and then copy and paste that URL into the "Add Link" function.
;-)
I tried to insert a link to "VBA Macro To Open A PDF File - My Engineering World" but couldn't get it to work. I have used the "Add Link" function in the past with no problems. I just realized that the URL I pasted in was lacking "https://" - I have corrected it. I remembered that I first need to copy and paste the URL into Word and then copy and paste that URL into the "Add Link" function.
;-)
WillieD24 (rep: 687) Jul 19, '24 at 9:53 pm
@Willlie - in case you haven't noticed, Forum newcomer royC is responding to a few old questions. I've already asked him to seek clarification through the Discussion threads- - not by posting his questions in a new Answer (as below),
John_Ru (rep: 6722) May 17, '25 at 9:48 am
@John
Yes, I had noticed and you did a nice job of informing him how to participate. I had considering doing the same but you beat me to it. It's clear he is not familiar with the Forum rules.
Yes, I had noticed and you did a nice job of informing him how to participate. I had considering doing the same but you beat me to it. It's clear he is not familiar with the Forum rules.
WillieD24 (rep: 687) May 18, '25 at 4:56 pm
Answers
0
Attach a sample pdf so we can see the data layout.
There are several ways to extract data from a PDF into Excel, depending on the format of the PDF and the tools you have available. Here are some effective methods:
Using Power Query in Excel – If your PDF contains structured tables, you can use Power Query to import and transform the data directly into Excel. This method is great for automating the process and handling messy tables.
Copy-Paste Method – If the PDF is text-based and not scanned, you can manually copy the data and paste it into Excel. Formatting may need adjustments.
Adobe Acrobat Export Tool – If you have Adobe Acrobat, you can use its built-in export feature to convert the PDF into an Excel spreadsheet.
Online PDF to Excel Converters – Websites like Smallpdf and iLovePDF offer free tools to convert PDFs into Excel files while preserving formatting.
Using Microsoft Word as an Intermediate Step – Convert the PDF to Word first, then copy the data into Excel for better formatting control.
If you prefer a visual guide, check out this video tutorial on using Power Query to extract data from a messy PDF table into Excel. Link: Enterprise Data Protection Included with Microsoft 365 Copilot Chat