hepeful
04-03-2007, 05:41 AM
Good morning :hi:
OK, I've read and used DRJ's code for "Combining All Workbooks From One Folder" and this works great. I need to look at 17 different spreadsheets daily so this minimizes the time, however the 17 workbooks are created daily (i.e. the folder that the combine macro looks at, now has over 100 spreadsheets). The 17 spreadsheets are run from an external system and placed in a shared folder. We keep the last 10 runs, but I only want to look at todays run. Is it possible show all of these as worksheets under one workbook for the current day? Something like, if date is equal to current day THEN combine.
Please help me save time, my only option is to cut/paste these into a different folder each day and while I can do this, it defeats the "automation" of using a macro.
Thanks
OK, I've read and used DRJ's code for "Combining All Workbooks From One Folder" and this works great. I need to look at 17 different spreadsheets daily so this minimizes the time, however the 17 workbooks are created daily (i.e. the folder that the combine macro looks at, now has over 100 spreadsheets). The 17 spreadsheets are run from an external system and placed in a shared folder. We keep the last 10 runs, but I only want to look at todays run. Is it possible show all of these as worksheets under one workbook for the current day? Something like, if date is equal to current day THEN combine.
Please help me save time, my only option is to cut/paste these into a different folder each day and while I can do this, it defeats the "automation" of using a macro.
Thanks