Excel 2000 (office 2000)

Is there an autosave feature that will save your data about 5 min. Not neccessarily auto recovery but save. This is for office 2000
LVL 3
timgreen7077Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
expert02232010Commented:
I believe the is an add-on tool that will provide that feature, I think it requires sr1.
0
 
MdraggaCommented:
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
jppintoCommented:
0
 
Arno KosterCommented:
Not that i am aware of, but it is easily implemented using a little macro such as :
note : place this code in a module, update the filename & location !
Public keep_saving As Boolean

Public Sub auto_save()

    If keep_saving Then
        Application.OnTime Now + TimeValue("00:00:05"), "auto_save"
        ThisWorkbook.SaveAs "c:\temp\test  " & Replace(Now, ":", "-") & ".xls"
    End If

End Sub

Open in new window


and place this code in thisworkbook:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
    keep_saving = False
End Sub

Private Sub Workbook_Open()
    keep_saving = True
    Application.OnTime Now + TimeValue("00:00:05"), "auto_save"
End Sub

Open in new window



0
 
Arno KosterCommented:
above macro saves the worksheet each 5 seconds, so also update the timevalue to :

"00:05:00"
0
 
timgreen7077Author Commented:
thanks
0
All Courses

From novice to tech pro — start learning today.