Auto save in excel 2000 keeps reverting to 10 minutes

J

JT Spitz

I keep trying to change the time between auto-saves to 30 minutes, but every
time I reopen excel 2000 it is back to 10 minutes. How do I get this change
to be permanent?

Thanks.
 
D

Dave Peterson

Create a workbook with this code in a general module:

Option Explicit
Sub auto_open()

On Error Resume Next
Workbooks("autosave.xla").Excel4IntlMacroSheets("Loc Table") _
.Range("ud01n.Frequency1").Value = 10
If Err.Number <> 0 Then
MsgBox "Timer not changed!"
Err.Clear
End If
On Error GoTo 0

'ThisWorkbook.Close SaveChanges:=False

End Sub

Save it into your XLStart folder (so it loads, runs, and closes each time you
start excel).

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

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.)
 
J

JT Spitz

Thanks for the information. Over the next few days I will try your macro
solution before I download anything new. I appreciate your quick response.

BTW, I may not be able to get back to this discussion thread as the search
for anything with my name (easier than any other type of search since I don't
log that many questions) only brings up items from 2008 and prior. I would
have to go through the list day by day/case by case to find this thread
again. I was lucky to find this as cases are, as you know, continually being
logged. The notify of any replies function also did not work here, there was
nothing in my email about your response. This situation happened a few
months ago and someone suggested I try logging cases a different way (can't
remember their suggestion), but I still see people are using this forum so
I'm a little confused. Anyway that is a separate issue that is low on the
priority list.

Getting this auto-save thing to work is higher on the list.

Thanks again.

JT
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top