Hello,
I have a folder with txt files. Each txt file can be opened in excel as a tab delimited file. Each text file has a line that says load date, and the date.
For instance like this: LOAD-DATE: April 23, 2010
Through Excel, I would like to create a macros that can create a worksheet that has the name of all the txt files in Column B and the respective Load Date pulled from the txt file in column C.
I have attached a sample workbook and two sample txt files.
Bookmarks