Each quarter I create 200 files and a separate file with 200 tabs. Each worksheet has information specific to one of the 200 files. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
Objective - to have each worksheet saved in the corresponding workbook. This is different than saving worksheets as separate files, here I want to save a specific worksheets to existing files.<o></o>
The worksheet name and the file name have the same first 4 characters - the filename has additional characters to designate the fiscal quarter, example: worksheet “ABCD” corresponds to file “ABCD-1Q11”. ( I can have the same name for both the tab and file.)<o></o>
Other information – The macro will be in a separate file in the same directory as the 200 files and the file containing the 200 tabs. Two ranges containing the worksheet names and the filenames are in the macro file. All files are Excel 2003. The 200 files are createdeach quarter by doing a “save as” on a standardized excel file looping through a range containing the file names.<o></o>
I would appreciate any guidance and code for this.<o></o>
Thanks<o></o>
Steven<o></o>
fficeffice" /><o></o>Objective - to have each worksheet saved in the corresponding workbook. This is different than saving worksheets as separate files, here I want to save a specific worksheets to existing files.<o
></o>The worksheet name and the file name have the same first 4 characters - the filename has additional characters to designate the fiscal quarter, example: worksheet “ABCD” corresponds to file “ABCD-1Q11”. ( I can have the same name for both the tab and file.)<o
></o>Other information – The macro will be in a separate file in the same directory as the 200 files and the file containing the 200 tabs. Two ranges containing the worksheet names and the filenames are in the macro file. All files are Excel 2003. The 200 files are createdeach quarter by doing a “save as” on a standardized excel file looping through a range containing the file names.<o
></o>I would appreciate any guidance and code for this.<o
></o>Thanks<o
></o>Steven<o
></o>
