Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoSave
Can I program Excel to autosave every one minute on a specified folder?
JPG |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoSave
If you're using Excel 2002 or newer, there is no Autosave as there was in
earlier versions. Autorecovery from ToolsOptionsSave is it. This is not the same as Autosave which made true incremental saves at intervals and alerted you before saving. Autorecovery just saves a temporary file which it deletes if Excel closes normally without incident. BTW.....Dave Peterson reports that he tried an earlier version of Autosave.xla in XL2002 and it seemed to work fine. I have also tried the Autosave.XLA from XL97 on 2002 and 2003 and does the job. To download the 97 version go here..... http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm In addition to the above......Jan Karel Pieterse has an addin called AutoSafe which also doen't alert before saving. 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. http://www.jkp-ads.com/Download.htm (look for AutoSafe.zip) Gord Dibben MS Excel MVP On Fri, 5 Oct 2007 09:08:02 -0700, juanpablo wrote: Can I program Excel to autosave every one minute on a specified folder? JPG |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoSave
Thank you.
One more thing, is it possible to automatically save as html? "Gord Dibben" wrote: If you're using Excel 2002 or newer, there is no Autosave as there was in earlier versions. Autorecovery from ToolsOptionsSave is it. This is not the same as Autosave which made true incremental saves at intervals and alerted you before saving. Autorecovery just saves a temporary file which it deletes if Excel closes normally without incident. BTW.....Dave Peterson reports that he tried an earlier version of Autosave.xla in XL2002 and it seemed to work fine. I have also tried the Autosave.XLA from XL97 on 2002 and 2003 and does the job. To download the 97 version go here..... http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm In addition to the above......Jan Karel Pieterse has an addin called AutoSafe which also doen't alert before saving. 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. http://www.jkp-ads.com/Download.htm (look for AutoSafe.zip) Gord Dibben MS Excel MVP On Fri, 5 Oct 2007 09:08:02 -0700, juanpablo wrote: Can I program Excel to autosave every one minute on a specified folder? JPG |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoSave
Ok it save as html first, then the add in will continue to autosave as html.
Great Thanks. "juanpablo" wrote: Thank you. One more thing, is it possible to automatically save as html? "Gord Dibben" wrote: If you're using Excel 2002 or newer, there is no Autosave as there was in earlier versions. Autorecovery from ToolsOptionsSave is it. This is not the same as Autosave which made true incremental saves at intervals and alerted you before saving. Autorecovery just saves a temporary file which it deletes if Excel closes normally without incident. BTW.....Dave Peterson reports that he tried an earlier version of Autosave.xla in XL2002 and it seemed to work fine. I have also tried the Autosave.XLA from XL97 on 2002 and 2003 and does the job. To download the 97 version go here..... http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm In addition to the above......Jan Karel Pieterse has an addin called AutoSafe which also doen't alert before saving. 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. http://www.jkp-ads.com/Download.htm (look for AutoSafe.zip) Gord Dibben MS Excel MVP On Fri, 5 Oct 2007 09:08:02 -0700, juanpablo wrote: Can I program Excel to autosave every one minute on a specified folder? JPG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoSave.xla Add-in | Setting up and Configuration of Excel | |||
Autosave add-in | Excel Worksheet Functions | |||
AutoSave | Excel Discussion (Misc queries) | |||
Opened Autosave but when closing workbook Autosave closes itself | Excel Worksheet Functions | |||
autosave | Setting up and Configuration of Excel |