Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to save workbook
Hi, i need a macro to save a workbook every 2 minutes.
Can this be done? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to save workbook
--Why dont you use the setting from menu ToolsOptionsSaveSettings'Save
AutoRecover info every' --A macro would look like the below Sub AutoSave() ActiveWorkbook.Save 'OR ThisWorkbook.Save '(as per your requirement) Application.OnTime Now + TimeSerial(0, 2, 0), "AutoSave" End Sub If this post helps click Yes --------------- Jacob Skaria "puiuluipui" wrote: Hi, i need a macro to save a workbook every 2 minutes. Can this be done? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to save workbook
Hi Jacob, is not autosaving the workbook. It's working only if i run the
macro. Can this macro be made to run by itself every 2 minutes? Thanks! "Jacob Skaria" wrote: --Why dont you use the setting from menu ToolsOptionsSaveSettings'Save AutoRecover info every' --A macro would look like the below Sub AutoSave() ActiveWorkbook.Save 'OR ThisWorkbook.Save '(as per your requirement) Application.OnTime Now + TimeSerial(0, 2, 0), "AutoSave" End Sub If this post helps click Yes --------------- Jacob Skaria "puiuluipui" wrote: Hi, i need a macro to save a workbook every 2 minutes. Can this be done? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to save workbook
Version prior to Excel 2002 had a real AutoSave which overwrote the workbook
with a save at specified time intervals. Good or bad feature depending on how you look at it. Versions since 2000 use Auto Recovery which only creates a timed but temporary backup file which is deleted when the workbook is saved or closed normally. Auto Recovery is a safety valve in the event of an Excel crash while a workbook is open. Jan Karel Pieterse has an addin called AutoSafe which doen't alert before saving. http://www.jkp-ads.com/download.asp (look for AutoSafe.zip) It doesn't overwrite the existing workbook when it saves. It saves to a user selectable folder. And when it's done, it either deletes these backups (or puts them in the recycle bin). And the user can always restore the backups from the recycle bin. If you still have access to the AutoSave add-in from Excel 2000 it may work with 2007................it did work with 2002 and 2003 I can send you the Autosave.xla from XL97 which apparently works under 2007 I know it works for 2002 and 2003 but have not tested for 2007. Gord Dibben MS Excel MVP On Wed, 7 Oct 2009 12:07:01 -0700, puiuluipui wrote: Hi Jacob, is not autosaving the workbook. It's working only if i run the macro. Can this macro be made to run by itself every 2 minutes? Thanks! "Jacob Skaria" wrote: --Why dont you use the setting from menu ToolsOptionsSaveSettings'Save AutoRecover info every' --A macro would look like the below Sub AutoSave() ActiveWorkbook.Save 'OR ThisWorkbook.Save '(as per your requirement) Application.OnTime Now + TimeSerial(0, 2, 0), "AutoSave" End Sub If this post helps click Yes --------------- Jacob Skaria "puiuluipui" wrote: Hi, i need a macro to save a workbook every 2 minutes. Can this be done? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Save just one sheet to new workbook. | Excel Worksheet Functions | |||
Macro to save Single Page to another workbook | Excel Discussion (Misc queries) | |||
writing a macro to save a workbook | Excel Worksheet Functions | |||
save workbook as current date using a macro | Excel Discussion (Misc queries) | |||
Macro: Exit active workbook without save? | Excel Worksheet Functions |