Is it possible to Autosave ActiveWorkbook in a specific period of time? Example set the workbook to autosave at 6:00 PM...
Is it possible to Autosave ActiveWorkbook in a specific period of time? Example set the workbook to autosave at 6:00 PM...
T-ogether
E-veryone
A-chieves
M-ore
One who asks a question is a fool for five minutes; one who does not ask a question remains a fool forever.
Take a look here http://www.cpearson.com/excel/ontime.htm
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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
moshe