autosave question

[art]

I notice that the autosave functionality only works with
an autorecover, rather than actually saving the file. I
am refreshing a query, and want to periodically SAVE the
file so other applications can read it. But, the new
autosave doesn't work this way. It only stores data in
a "autorecovery" file. Therefore, other applications
will never see the refreshed data.

Is there any way to actually SAVE an Excel spreadsheet on
a timed basis?

Thanks,

Art

 

[Frank Kabel]

Hi
a repost from Dave Peterson:
------
Short descriptions:

Autosave (an addin in xl versions before xl2002), the workbook gets
saved at
user selectable intervals (just like a manual save). (If you're
running
xl2002+, then if you can find a copy of autosave, it'll work with that
version,
too.)

xl2002+ has a feature called autorecovery. It's used to catch
catestrophic
events (excel/windows crashing). But it won't help if you never save
or you
close excel normally.

But Jan Karel Pieterse has an addin that's the best of both worlds:
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.

=====
You may want to get a copy of Jan Karel's addin. It might save a few
tears in
the future.

http://www.jkp-ads.com/Download.htm
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)

 

[Gord Dibben]

Art

In addition to Frank's posting...........

There is no Autosave in XL2002 and 2003 as there was in earlier versions.

Autorecovery is it. This is not the same as Autosave.

BTW.....Dave Peterson reports that he tried an earlier version of Autosave.xla
in XL2002 and it seemed to work fine.

I have also tested the Autosave.XLA from XL97 and does the job on Excel 2002
and 2003.

To download the 97 version go here.....

http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

Gord Dibben Excel MVP