Solved

Excel 2000 (office 2000)

Posted on 2011-03-14
7
271 Views
Last Modified: 2012-05-11
Is there an autosave feature that will save your data about 5 min. Not neccessarily auto recovery but save. This is for office 2000
0
Comment
Question by:timgreen7077
7 Comments
 
LVL 6

Expert Comment

by:expert02232010
ID: 35129094
I believe the is an add-on tool that will provide that feature, I think it requires sr1.
0
 
LVL 6

Accepted Solution

by:
expert02232010 earned 500 total points
ID: 35129104
0
 
LVL 7

Expert Comment

by:Mdragga
ID: 35129113
0
Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
LVL 33

Expert Comment

by:jppinto
ID: 35129121
0
 
LVL 19

Expert Comment

by:akoster
ID: 35129160
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
 
LVL 19

Expert Comment

by:akoster
ID: 35129173
above macro saves the worksheet each 5 seconds, so also update the timevalue to :

"00:05:00"
0
 

Author Closing Comment

by:timgreen7077
ID: 35132872
thanks
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question