Application.AutoRecover.Enabled = False
-----------
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Sedgwick"

wrote in message
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.