Close Document Recovery window in Excel

[Nathan323]

Hi.

Can't close with winkill or winclose. Doesn't have Control ID when using autoit info tool, tried

WinClose("","[Document Recovery]"), doesn't work..

[Mat]

Welcome to the forums

When you hover over the window with the autoit info tool, what does it say under the Window tab (title and class rows are the useful ones)?

In your above code you are searching for a window, that has "[Document Recovery]" as the window text, is that what you intended?

[water]

Welcome to AutoIt and the forum!

How do you open the Excel file? Do you use the Excel UDF that comes with AutoIt?

[Nathan323]

Hi, thanks for the quick replies

I am not using the UDF, I am pretty new to this and so far have been writing this code while I'm supposed to be doing other things at work hehe.

We use an Excel based form setup to manage order in a warehouse. Every now and it bugs out and we have to click End, open process manager, kill process, restart Excel and open the form input boxes again. When it's shut down this way, the document recovery pane opens on restart (I tried to prevent this from happening but I was unsuccessful, I think because it was protected..)

In the control tab of the info tool it says in Advanced Mode field: [CLASS:bosa_sdm_XL9; INSTANCE:1] Nothing in the Name or ID fields..

[water]

If you check the help file you will see that there are many ways so specify a ControlID. One is to pass the value as you specified above.

So function ControlClick should be able to close this popup.

[Nathan323]

Yeah I tried that. Here is my code:

1. ProcessClose ("excel.exe")

2.

3. (some keystrokes that start

4. shortcut)

5.

6. WinWaitActive("ROS Items")

7.WinKill("ROS Items")

' this hastens close splash screen

8.ControlClick("","Document Recovery","[CLASS:bosa_sdm_XL9; INSTANCE:1] ")

This opens ok, but doesn't close the Document Recovery pane.

[water]

I think you have to at least pass the title of the window as first parameter:

ControlClick("Name of the window","Document Recovery","[CLASS:bosa_sdm_XL9; INSTANCE:1]")

[Nathan323]

The document Recovery pane seems to have no window name. Here is a screenshot http://sdrv.ms/17Vc4JE. This is with the Control tab shown I know, but its the only one I have now that Im home and can upload it. The window tab shows nothing in the Name field, or ID field. It also shows code that showed me trying to WinKill the window using Title text, when that didnt work I changed to code in above post, also didnt work.

[water]

To address the window you could use the class as well.

[Nathan323]

Sorry, what does that mean?

Like this?

WinClose("","Document Recovery","[CLASS:bosa_sdm_XL9; INSTANCE:1]")

I tried that and it didnt work either. Something to note as well, without the class in the above code, it closes Excel entirely. Without it, no response.

[water]

If you use the AutoIt Window Info tool you get a title and a class for the window. Use the class to name the window where you want to click the control:

ControlClick("Class as returned by the Window Info Tool","","[CLASS:bosa_sdm_XL9; INSTANCE:1]")

[Nathan323]

ok thanks, ill try that

[Nathan323]

Ok tried it on Friday, still didn't close it. The only that has worked is mouse click, but the pointer moving slowly towards the button is disturbed bu the users hand if their hand moves the mouse while the script is executing...

[water]

Can the behavior be reproduced by opening a worksheet and then killing Excel in the task manager.

[water]

BTW: Which Excel version do you run? Excel 2000 as I interpret the string "XL9" in the ControlID?

[Nathan323]

Yes same behaviour.

Excel 2010.

[water]

I will test as soon as I'm in my office again.

[water]

I have Excel 2010 (german) here as well but unfortunately I don't get any useabel information from AutoIt Window Info tool to click the close button.

But it looks like you can modify the behavior by setting registry keys. Maybe this helps.

[water]

Another idea:

Looks like you can deactivate the document recovery by setting Excel options. Options -> Save/Store -> Document Recovery (translated from the german version)

[Nathan323]

Ok thanks for the suggestions. Following the regedit instructs, under Office I had 11.0, 12.0, 13.0 etc. Only under 15.0 was there a full list of office progs, including excel. But under Excel, there was no ExtractDataDisableUI option.

I also tried switching off the document recovery option for that workbook, but it turns it self back on and unchecks the options check box on restart. The sheet is unprotected and the workbook is unprotected, not sure if that would've mattered. Though the icon for the file in Windows explorer has an yellow/orange exclamation mark on it, does that mean its locked in some way? I check user permissions and its full for all users..