Sign in to follow this  
Followers 0
Nathan323

Close Document Recovery window in Excel

21 posts in this topic

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..

Share this post


Link to post
Share on other sites



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?

Share this post


Link to post
Share on other sites

Welcome to AutoIt and the forum!

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


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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..

Share this post


Link to post
Share on other sites

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.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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]")

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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]")

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

ok thanks, ill try that :)

Share this post


Link to post
Share on other sites

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...

Share this post


Link to post
Share on other sites

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


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Yes same behaviour.

Excel 2010.

Share this post


Link to post
Share on other sites

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


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Another idea:

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


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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..

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0