I have a set of test files; each file a set of data for one month. I have 60 files. The name scheme of each file is:
wgt.081 (jan 2008)
wgt.082 (Feb 2008)
wgt.08a (Oct 2008)
wgt.08b (Nov 2008)
wgt.08c (Dec 2008)
Each file has 5 columns of data (each line is comma delimited)
I wanted a VBA proc that would read in all 60 files in a directory and stack these in one sheet. As each file is read in I wanted to add a 6th column that being the filename. (Later in Excel I could convert this column to read dates).
I attempted this. One problem is that when Excel goes to open the file, I get a file open error (file does not match the filetype given). The VBA does not go beyond the first file.
I have attached my primary Excel workbook - the VBA program 'PerformanceStyleMap' is the proc. (There are other procs in this file, but these are not used. I have also attached 6 of the text files. R1G.xls
I also need the proper copy&paste command.
Note: if there is a Python solution, I am open to that as well.