Application.AutoRecover Property (Excel)
Published: July 16, 2012
Returns an AutoRecover
object, which backs up all file formats on a timed interval.
A variable that represents an Application object.
Valid time intervals are whole numbers from 1 to 120.
In this example, the Time property is used in conjunction with the AutoRecover property to set the time interval for Microsoft Excel to wait before saving another copy to five minutes.
Application.AutoRecover.Time = 5
MsgBox "The time that will elapse between each automatic " & _
"save has been set to " & _
Application.AutoRecover.Time & " minutes."
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback