Is there a code that can autosave a workbook lets say every 10 minutes? I know there is the auto recover function but I need something that actually saves the document.
Is there a code that can autosave a workbook lets say every 10 minutes? I know there is the auto recover function but I need something that actually saves the document.
Try this
Regards,Option Explicit Public dtime As Date Public Sub SaveMacro() dtime = Now + TimeValue("00:10:00") ThisWorkbook.Save Application.OnTime dtime, "Savemacro" End Sub
Avinash
Last edited by Avinash Beepath; 12-10-2010 at 06:47 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks