Main.xls is a workbook that has an Auto_open macro that saves the workbook automatically as Sam_mm_dd.xls in path c:\Files\
So when Main.xls is opened on Feb 10, its gets saved as Sam_2_10.xls
Now, multiple users will access this workbook during the day, so when Main.xls is opened for the second time in the day, the user gets a prompt 'Sam_2_10.xls already exists, overwrite Y/n, etc'
Instead of that, I want a macro that will realize that this user needs to open Sam_2_10.xls from C:\Files\ and should automatically revert to that auto saved workbook, instead of offering to overwrite it and wipe off all thats been done previously for the day.
From the users perspective, there need not be any intervention, the user just opens Main.xls, if it has not yet been auto saved for the day, excel will do it for them. And if it has already been auto saved, excel will open the relevant workbook for them.
Any Suggestions
So when Main.xls is opened on Feb 10, its gets saved as Sam_2_10.xls
Now, multiple users will access this workbook during the day, so when Main.xls is opened for the second time in the day, the user gets a prompt 'Sam_2_10.xls already exists, overwrite Y/n, etc'
Instead of that, I want a macro that will realize that this user needs to open Sam_2_10.xls from C:\Files\ and should automatically revert to that auto saved workbook, instead of offering to overwrite it and wipe off all thats been done previously for the day.
From the users perspective, there need not be any intervention, the user just opens Main.xls, if it has not yet been auto saved for the day, excel will do it for them. And if it has already been auto saved, excel will open the relevant workbook for them.
Any Suggestions