You shouldnt even have to save the workbook that runs the code since that is all the extra workbook is for.


As for the double commas deal yes that can easily be added (I may be able to have it done later tonight)
As for the column D not getting fixed that is strange. You mentioned a 2nd folder? are you running the code for just one folder? it will only change documents ending in .xls or .xlsm that may be the problem because I believe .xlsx is a valid extension. I will change that. are there any other file types it may have skipped.

I will try to get the corrected code to you soon.

>> .xlsx is a valid extension. I will change that. >>
I am receiving all my documents first as PDF, and the I am converting them to Excel. Is there a more suitable format you prefer that I should export as? I am currently using Excel 2007.

>> You shouldn't even have to save the workbook that runs the code since that is all the extra workbook is for. >>
Interesting. just open an excel file and insert a module, paste the code and run it? I can't seem to run F8 without saving it as a macro book.

>> As for the column D not getting fixed that is strange. You mentioned a 2nd folder? are you running the code for just one folder? >>
I have multiple folders under one directory. Each directory is a category, and in each folder is a set of PDFs, that i convert to Excel and then run your code.
I am running the code in one folder at a time. then I moved to the next folder and run your code in that folder... and the process continues till I've gone through all Excel files in every folder under a main directory.