How to save same excel workbook in different folders as a back up

G

GRAPH WITH A MACRO

I mean, as we do the work in excel it should automatically save in another
workbook as backup copy... it should be updated as we save the workbook.
 
J

Joel

You would need to write your own macro using the before save event or on open
event. The macro would move previous saved versions do an archieve directory.
 
Top