Script in order to open a pdf file, select all, copy, then paste into a new excel sheet?

like the question states, I need to create a script in order to open 1 or more pdf files, then select all the contents, then paste it into new sheets in excel. i don't know what language would be the best to accomplish this so I need some ideas.

Thanks!
jtovar3Asked:
Who is Participating?
 
Robberbaron (robr)Connect With a Mentor Commented:
most pdf readers/extractor only allow output of unformatted text.

this wont paste well into excel.  But you may be able to then script the reformat process.

freeware pdf2txt
http://www.a-pdf.com/text/
http://text-mining-tool.com/
http://www.colorpilot.com/extract-pdf-text.html

all of there have a command line app that you can script using batch files / vba / vbs.  Personally I would look at the VBA method from within the target XL file.
0
 
Karl Heinz KremerCommented:
Acrobat X allows to save a PDF document as an Excel spread sheet. You can download a 30 day eval version to see if that would fit your needs. If that works, we can work on automation.
0
 
jtovar3Author Commented:
Thanks for the great recommendations!

A-PDF text works like a charm, but I have no idea where to start in order to write a script to open the program and run it in order to convert the file. do you think you can provide any insight into that?

Thanks so much!
0
 
Karl Heinz KremerCommented:
Sorry, I am not familiar with A-PDF.
0
 
Robberbaron (robr)Commented:
The command line version is what is needed to script. But it is not free.$35. See the web page link to batch examples.
Ill see if there are other free options
0
All Courses

From novice to tech pro — start learning today.