AutoRecover Object Excel Add-in VBA (Visual Basic for Applications)

AutoRecover Object Excel Add-in VBA (Visual Basic for Applications)

AutoRecover

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.

VBA code

Sub SetRecoveryPath() 
	Application.AutoRecover.Path = "D:\MyRecoverDirectory" 
End Sub

Time

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.

Leave a Reply

Your email address will not be published.