Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I have Excel automatically save a file periodically?
I need to have Excel save a file every 30 minutes without any input from the
user. It can overwrite the previous save each time. The "auto-recover" doesn't give us what we need. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I have Excel automatically save a file periodically?
xl2k and lower had an addin called autosave.xla.
If you can find an old version of that addin (old CD/floppy or an old pc???), it'll work with newer versions of excel (through xl2007 at least). ps. Gord Dibben posted this: Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003. If you have a previous copy, move it to your Office\Library. To download the 97 version see here........ http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm wrote: I need to have Excel save a file every 30 minutes without any input from the user. It can overwrite the previous save each time. The "auto-recover" doesn't give us what we need. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I have Excel automatically save a file periodically?
That requires a macro or 2.
Right click the XL icon in the upper left hand corner of Excel and select View Code. Paste the following in the code window that opens up. Private Sub Workbook_Open() Application.OnTime Now + TimeSerial(0, 30, 0), "SaveMe" End Sub On the Insert menu select Module. Paste the following. Public Sub SaveMe() ThisWorkbook.Save Application.OnTime Now + TimeSerial(0, 30, 0), "SaveMe" End Sub Next time you open this workbook it will background save the file for you... -- HTH... Jim Thomlinson " wrote: I need to have Excel save a file every 30 minutes without any input from the user. It can overwrite the previous save each time. The "auto-recover" doesn't give us what we need. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I have Excel automatically save a file periodically?
Dave
That site is no longer available. If OP wants to email me at gorddibbATshawDOTca I can send a copy of Autosave.xla which works with 2007 with or without prompt. Gord On Tue, 20 Oct 2009 13:01:58 -0500, Dave Peterson wrote: xl2k and lower had an addin called autosave.xla. If you can find an old version of that addin (old CD/floppy or an old pc???), it'll work with newer versions of excel (through xl2007 at least). ps. Gord Dibben posted this: Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003. If you have a previous copy, move it to your Office\Library. To download the 97 version see here........ http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm wrote: I need to have Excel save a file every 30 minutes without any input from the user. It can overwrite the previous save each time. The "auto-recover" doesn't give us what we need. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel files, periodically, taking a long time to save or open | Excel Discussion (Misc queries) | |||
Users periodically get 0 byte size files on initial save to networ | Excel Discussion (Misc queries) | |||
Excel automatically resets default save file format | Excel Discussion (Misc queries) | |||
How to Periodically Store/Save Excel DDE Values | Excel Discussion (Misc queries) | |||
Automatically save a file in another directory | Excel Discussion (Misc queries) |