View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sedgwick Sedgwick is offline
external usenet poster
 
Posts: 4
Default Disabling Document AutoRecovery in Excel by script

Due to a dependency on legacy excel based applications, we have a need to
disable the Document AutoRecovery function within Excel 2003, to minimise
risk of corrupting the application.

ScriptCenter has a snippet of code for enabling AutoRecover, though it is
already enabled by default =/

Set objExcel = CreateObject("Excel.Application")
objExcel.AutoRecover.Enabled
objExcel.Quit

I have tried a number of alternatives but still cannot get the Disable
AutoRecovery checkbox ticked. It's location is (Within Excel) Tools, Options
[Save]

All customise functions of AutoRecovery are registry based, EXCEPT
Enable/Disable.

Any assistance would be greatly appreciated.