Open multiple PDF files from certain path

Hi all,

I have found a code that opens up a single pdf document and then from there I can save it as a txt file then open it and copy the text into excel. But I want to do it to multiple pdf files that are in the same folder - this part I'm having a problem with. So once it saves it as a text file open the first one up copy the data in column A, then loop to the next pdf save it as the same text file name that's ok then paste the data in column B.

Any help would be much appreciated.

Code below:

Please Login or Register  to view this content.

Awesome!! That worked.

Thank you so much JBeaucaire!!!

I just left the text file name as the one name though as I didn't want heaps of text files, just wanted them stored into excel.

Thanks again!