Thanks for responding. I need to: * open the first file (.doc extension) * copy the contents *close the doc file *paste the contents of the clipboard into the first empty cell of column A in an Excel file *repeat for each .doc file in the folder So I will end up with all of the contents of each file in column A of a single Excel file. From there I can manipulate the contents of the Excel file with some basic text to columns and other Functions.
I have approximately 4000 files I need to open and then copy/paste the contents into an Excel file (at the last empty cell of column A) so that all of the contents of each file ends up in one Excel file. Any help would be much appreciated.