newshound12
Active Member
- Joined
- Feb 19, 2003
- Messages
- 339
When closing a workbook, automatically save it as an .xlsm workbook with next Sunday’s date (MM-DD-YY) in a folder created also with next Sunday’s date.
Also save an .xlsx copy of the workbook with the name of the day of the week (Monday thru Saturday, Sunday’s save will be the actual date) in the same folder.
The .xlsm can be overwritten after a message box asks “Do you want to overwrite existing file or rename it as a copy”.
Also save an .xlsx copy of the workbook with the name of the day of the week (Monday thru Saturday, Sunday’s save will be the actual date) in the same folder.
The .xlsm can be overwritten after a message box asks “Do you want to overwrite existing file or rename it as a copy”.