Hey,
I have multiple files in multiple subfolders that have data in them that I would like placed into rows along in the workbook the macro is run from.
A couple points to note are:
-The files are all going to be xls files of some sort
-The folders and subfolders will contain various other files like .doc or .txt that should be skipped
-Some of the files may be corrupt or protected
-There are hundreds of files and many subfolders
-The files will contain a number of sheets, the one with the data in it is called 'QUOTE'
-Along the top I need the titles of the cells the data has come from and the data to be organised like this:
B7 l B8 l B11 l B13 l
----------------------
1 l 1 l 1 l 1 l
----------------------
2 l 2 l 2 l 2 l
Any help is appreciated
Thanks in advance
I have multiple files in multiple subfolders that have data in them that I would like placed into rows along in the workbook the macro is run from.
A couple points to note are:
-The files are all going to be xls files of some sort
-The folders and subfolders will contain various other files like .doc or .txt that should be skipped
-Some of the files may be corrupt or protected
-There are hundreds of files and many subfolders
-The files will contain a number of sheets, the one with the data in it is called 'QUOTE'
-Along the top I need the titles of the cells the data has come from and the data to be organised like this:
B7 l B8 l B11 l B13 l
----------------------
1 l 1 l 1 l 1 l
----------------------
2 l 2 l 2 l 2 l
Any help is appreciated
Thanks in advance