Helps to perform auto recovery of a workbook. AutoRecover object exposes various properties to determine the path and time interval for backing up all files. Below code will set auto recovery path of current workbook.
Sub SetRecoveryPath() Application.AutoRecover.Path = "D:\MyRecoverDirectory" End Sub
Sub SetRecoveryTime() Application.AutoRecover.Time = 10 End Sub
Above code will perform recovery of current workbook in every 10 minutes interval and save at “D:\MyRecoverDirectory“
Please leave your comments or queries under comment section also please do subscribe to out blogs to keep your self upto date.