how to set up an automated saving?

zzzzimen

New Member
Joined
Sep 17, 2014
Messages
2
Hi
I was wondering if there are any ways to set up a document to automaticly save itself, just like clicking the save button, but on a timer?
Im using Excel 2013 on a windows 7 device.
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

ParamRay

Well-known Member
Joined
Aug 6, 2014
Messages
1,195
.
.

Code:
Sub SaveBook()

    ThisWorkbook.Save
    Application.OnTime _
        EarliestTime:=Now + TimeValue("00:00:05"), _
        Procedure:="SaveBook"

End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,108,624
Messages
5,523,968
Members
409,547
Latest member
AW2020

This Week's Hot Topics

Top