Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to open an excel document saved in a temporay file | Excel Discussion (Misc queries) | |||
Excel won't open the original document!!! | Excel Discussion (Misc queries) | |||
Difficult for me, probably basic to you | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel crashes when opening excel document by double-clicking icon | Excel Discussion (Misc queries) |