Auto Save question

[dfsobral]

hy

i'm presently working in a code that takes a few minutes to run, can go easily to 20/30 minutes depending on what the user wants

i already disable cancel key so the user may not stop the completion of the code but a potencial problem come to mind

what if the user force a crash of excel because assumed it was no longer running?

is it possible that excel autosave the file between the time the code starts and the crash occur?

because in this case the recovered file would be a bad one

is there a command that i could use to disable autosave in the beginning of the program and enable it at the end?

thanks

 

[Roderick_E]

First you might want to try this code to optimize your macro:

'Display wait for a moment
Application.StatusBar = "****Please Wait*****  Macro processing"
'opitmize macro by disabling all processes that slow it down.
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False
Application.DisplayAlerts = False
Application.AskToUpdateLinks = False






'Re-enable screenupdating (before END SUB)
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
Application.EnableEvents = True
Application.DisplayAlerts = True
Application.AskToUpdateLinks = true
Application.StatusBar = False

You can disable and enable auto save this way:

Application.AutoRecover.Enabled = False 'disable
Application.AutoRecover.Enabled = True 'enable

 

[dfsobral]

thanks

usually don't use
Application.StatusBar
Application.AskToUpdateLinks

will add it, everything that can make it run faster is good