I know that there are programs out there that will convert a PDF into excel, but what I need to know is, is there a way for excel to access values (numbers) in a PDF and then use those values in a worksheet?
So, if I have a table in a PDF file - containing part numbers, descriptions and quantities ordered, I want to be able to extract the part numbers and QTY, and have them populate an excel table?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi FD
Perhaps you know this way but as i know this way(from the Greek forum) i just share with you.
http://www.pdfconverter.com/resource...oexporttoexcel
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks for the link Fotis
However, I dont want to convert the PDF, I want to be able to just pull info from it (as if it were another excel workbook). Kinda like...get the data in "b3" in the PDF (yes I know PDF's dont have rows/columns), and then put that data into sheet1!C3
Hi FDibbins..
but as soon as it comes in excel boundary.. you can format it according to you.. tyr this..yes I know PDF's dont have rows/columns
https://groups.google.com/forum/?fro...os/hPZsy2QyFGM
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
I do NOT want to import the PDF, I just want to access the data inside it.
@ Debraj Roy,
From my point of view that is a fake method... Did you seen the code?? He just opening the PDF file from the root path and using sendkey (Ctrl+A ^a) to select all and just doing the copy process (Ctrl+C ^c) and exiting the PDF using (Ctrl+q ^q)
Not a better approach.....
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
maybe this one.???
http://www.siddharthrout.com/2012/01...an-excel-file/
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
That looks promising Vlad, thanks. I need to spend some time and see if it will work for what I need
Hi FDibbins,
I was working on the same thing earlier this year; our software package makes reports but we can't copy and paste them, which is crazy. We can print them, however, and when they get sent to the printer, it's selectable text. Unfortunately, PDF readers don't all work the same when it comes to text selection and copying. On my mac, Preview's decentat copying tables, but generally it's not the best. On my PC, I tried a bunch of readers—like Adobe Reader, Firefox's built-in reader, and PDF Architect. PDF Architect was far superiour. However, with PDF Architect, you select the stuff you want to copy as a table, then right click it and click "copy as table." You can't just press ctrl+c. I'd encourage giving PDF Architect a try. You might have to copy more columns than you want, and then delete the superfluous columns in Excel.
-Scott
This site might be of interest to you. There is a claim that the software will extract all tables from a PDF file and export to an Excel file. There seems to be two versions. One is cloud based and the other is a desktop version. There is a free trial for the desktop version and there is a free version in the cloud though use is limited per month.
https://www.pdftoexcelonline.com/
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
What I am working on (for my daughter, who is just starting out learning about excel), is that she gets a PDF file - generated from a proprietary excel program (cant change it, or even get a copy to look at) - and then needs to re-enter that data into another excel workbook, manually.
The PDF is generated at least daily, so pulling the PDF through a converter would be just as slow as manually entering the data. Im trying to see if there is an automatic way to "peek" inside the PDF, find specific data, and then populate the 2nd excel workbook.
Vlad's link looks like it may be what I need, but my VBA is below beginner at best
self-deleted duplicate post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks