copy data from PDF file to excel sheet

[neveu]

hello forum,

i have several PDF file in a directory on my computer,

i would like to copy the information from each PDF file and copy it to a separate sheet . after i copy it i would need to do a text to columns (space as delimitator) for the information.

could you please help me with a VBA code. this would save a lot of time for time and avoid a lot of boring open file - copy - paste - text to column, next next ok.

thank you,
neveu

 

[Derek Brown]

Have you thought about software such as Able2Extract?
http://www.investintech.com/able2extract.html

 

[neveu]

I've checked it and it seems a good tool.
however, i was aiming for a cheaper solution - preferably free , that's why i was thinking of VBA.

 

[Derek Brown]

I have never seen any VBA code to do what you want.
I have used Able2Extract and PDF2XL (http://www.cogniview.com/).
You could have a look at Nitro PDF Software (http://www.pdftoexcelonline.com/) that may be free, but I have not used it.

I see that Able2Extract appears to have a 'batch' option but I have not used that, yet.