AutoSave Script for Excel

[simdan42]

What is the best way to get excel to auto save a file every 5 minutes?

 

[PHV]

Doesn't already exists an (optional) AutoSave AddIn ?
Check the installation options.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[simdan42]

So you do not believe thtere is a way to write a script that runs in the backgrown to see the system time and if is has been a certain about of time run a save command?

 

[PHV]

AFAIK, up to Excel 2000, an AutoSave add-in was optionally installable.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[rss01]

simdan42,

Will this help?

http://www.tek-tips.com/faqs.cfm?spid=68&newpid=68&sfid=4060

 

[simdan42]

Seems to work! Thanks!

 

[simdan42]

One more thing. Is there a way to add a button to the toolbar to enable and disable the add-in. I would like it to auto save most of my files but if I am using excel to do some scratch calculations I do not want it to save.