I'd like to write a macro so that any time the main document is saved, a copy of the document is saved to another file with the current date in the title. So for example when I click to save "Schedule.xls" on 01/01/01, the macro automatically saves the document in its current place and also saves "Schedule 01/01/01.xls". Also, each save would overwrite the previous version if a document is saved multiple times in one day. Any help?