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.