Thread: How to save same excel workbook in different folders as a back up
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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.
Reply With QuoteReply With Quote