Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - CSV file, trying to save a date as text, reverts back to d | Excel Worksheet Functions | |||
I did not save changes in Excel and now I lost data. Go Back? | Excel Discussion (Misc queries) | |||
Help with Creating folders on Save | Excel Discussion (Misc queries) | |||
SAVE is not available in Excel under FILE. How do I get it back? | Excel Discussion (Misc queries) | |||
How can I batch open a txt file in excel 2003 and save back as a . | Excel Discussion (Misc queries) |