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

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.

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

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.

"GRAPH WITH A MACRO" wrote:

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.

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

Or use SaveCopyAs

See the VBA help

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Joel" wrote in message ...
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.

"GRAPH WITH A MACRO" wrote:

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.