Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 autosave a changing file
I need to have Excel 2003 save a changing file automatically and
periodically. This was available as an add-in in earlier versions. This capability is fundamental to unattended (lab) data collection. What to do? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 autosave a changing file
If you still have autosave.xla from a previous version of excel, it'll work with
xl2003. Jan Karel Pieterse wrote an addin (works in any version) called AutoSafe (note spelling). 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, not autosafeVBE.zip, for your purposes.) LeProf wrote: I need to have Excel 2003 save a changing file automatically and periodically. This was available as an add-in in earlier versions. This capability is fundamental to unattended (lab) data collection. What to do? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 autosave a changing file
LeProf
As you have discovered, if you're using Excel 2002 or 2003, there is no Autosave in XL2002 and 2003 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 Wed, 17 Jan 2007 15:51:01 -0800, LeProf wrote: I need to have Excel 2003 save a changing file automatically and periodically. This was available as an add-in in earlier versions. This capability is fundamental to unattended (lab) data collection. What to do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - When I open files, why are some file names blue? | Excel Discussion (Misc queries) | |||
Excel 2003 crashes when opening a file from one particular user | Excel Discussion (Misc queries) | |||
Sharing read-write Excel 2003 files | Excel Discussion (Misc queries) | |||
Insert & link a graphic file in Excel 2003 -- updatable pictures! | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |