Prev: How do i do an eblast from an excel spreadsheet, that has email's
Next: Cell fill color changes by itself
From: Peter V Peter on 14 Apr 2010 18:14
I want to set Excel or any Office document to auto save at a set interval.
Not just autorecover.
From: Dave Peterson on 14 Apr 2010 19:04
AutoSave was removed with xl2002. But if you have an old version of
autosave.xla (it came with earlier versions of excel), it'll still work in the
newer versions (xl2002+).

If you don't have a copy available...

Another option would be to dump autosave and use Jan Karel Pieterse's 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.)

Peter V wrote:
>
> I want to set Excel or any Office document to auto save at a set interval.
> Not just autorecover.

--

Dave Peterson
From: Gord Dibben on 15 Apr 2010 10:56
I have a copy of the older AUTOSAVE.XLA that Dave refers to.

If you want it, email me at gorddibbATshawDOTca

Change the obvious.


Gord Dibben MS Excel MVP

On Wed, 14 Apr 2010 18:04:49 -0500, Dave Peterson
<petersod(a)verizonXSPAM.net> wrote:

>AutoSave was removed with xl2002. But if you have an old version of
>autosave.xla (it came with earlier versions of excel), it'll still work in the
>newer versions (xl2002+).
>
>If you don't have a copy available...
>
>Another option would be to dump autosave and use Jan Karel Pieterse's 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.)
>
>Peter V wrote:
>>
>> I want to set Excel or any Office document to auto save at a set interval.
>> Not just autorecover.

 | 
Pages: 1
Prev: How do i do an eblast from an excel spreadsheet, that has email's
Next: Cell fill color changes by itself