Auto SAve

[jammer6_9]

Is it possible to Autosave ActiveWorkbook in a specific period of time? Example set the workbook to autosave at 6:00 PM...

[Bob Phillips]

Take a look here http://www.cpearson.com/excel/ontime.htm

[lior03]

what about:
[VBA]
Sub deluxer()
On Error Resume Next
Dim x As Integer
Dim wb As Workbook
Application.OnTime Now + TimeSerial(0, 0, 300), "deluxer"
For Each wb In Application.Workbooks
If wb.name <> ActiveWorkbook.name Then
Application.StatusBar = " now saves - " & ActiveWorkbook.name
wb.Save
End If
Next
Application.StatusBar = ""
Exit Sub
End Sub

[/VBA]
a workbook is saved automatically every 5 minutes
thanks