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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Merge Multiple workbook sheets into one workbook 0
How to create absolue path link to another workbook (Excel 2003) 1
Excel 2003 save as .XLSX 10
excel 2010 + copy array 3
File Protection with Save as & Copy option disable 4
Active Workbook 8
Excel 2000 with Compatibility Pack can't Save As Excel 2007 docume 1

Top