Improve company productivity with a Business Account.Sign Up

x
?
Solved

Excel 2000 (office 2000)

Posted on 2011-03-14
7
Medium Priority
?
282 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 2000 total points
ID: 35129104
0
 
LVL 7

Expert Comment

by:Mdragga
ID: 35129113
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
LVL 33

Expert Comment

by:jppinto
ID: 35129121
0
 
LVL 19

Expert Comment

by:Arno Koster
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:Arno Koster
ID: 35129173
above macro saves the worksheet each 5 seconds, so also update the timevalue to :

"00:05:00"
0
 
LVL 11

Author Closing Comment

by:timgreen7077
ID: 35132872
thanks
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
This is a comprehensive review of a bundled Toolkit designed for use by IT Professionals and End Users to help Microsoft Outlook fans manipulate Outlook files and repair some common problems. Enjoy...
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

606 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