I have a workbook on a network. Multiple people access and change the workbook throughout the day.
I would like to automatically save the workbook into a network folder every evening (say 7pm). The file should be saved as FILENAME,today's date(ddmmyyyy).
The idea is to have a reliable and complete archive of the daily changes made to the file.
Any suggestions are welcome and much appreciated!
Bookmarks