Nathan323 Posted July 3, 2013 Share Posted July 3, 2013 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.. Link to comment Share on other sites More sharing options...
Mat Posted July 3, 2013 Share Posted July 3, 2013 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? AutoIt Project Listing Link to comment Share on other sites More sharing options...
water Posted July 3, 2013 Share Posted July 3, 2013 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Nathan323 Posted July 3, 2013 Author Share Posted July 3, 2013 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.. Link to comment Share on other sites More sharing options...
water Posted July 3, 2013 Share Posted July 3, 2013 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Nathan323 Posted July 4, 2013 Author Share Posted July 4, 2013 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. Link to comment Share on other sites More sharing options...
water Posted July 4, 2013 Share Posted July 4, 2013 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Nathan323 Posted July 4, 2013 Author Share Posted July 4, 2013 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. Link to comment Share on other sites More sharing options...
water Posted July 4, 2013 Share Posted July 4, 2013 To address the window you could use the class as well. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Nathan323 Posted July 4, 2013 Author Share Posted July 4, 2013 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. Link to comment Share on other sites More sharing options...
water Posted July 4, 2013 Share Posted July 4, 2013 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Nathan323 Posted July 4, 2013 Author Share Posted July 4, 2013 ok thanks, ill try that Link to comment Share on other sites More sharing options...
Nathan323 Posted July 7, 2013 Author Share Posted July 7, 2013 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... Link to comment Share on other sites More sharing options...
water Posted July 7, 2013 Share Posted July 7, 2013 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
water Posted July 7, 2013 Share Posted July 7, 2013 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Nathan323 Posted July 8, 2013 Author Share Posted July 8, 2013 Yes same behaviour. Excel 2010. Link to comment Share on other sites More sharing options...
water Posted July 8, 2013 Share Posted July 8, 2013 I will test as soon as I'm in my office again. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
water Posted July 8, 2013 Share Posted July 8, 2013 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
water Posted July 8, 2013 Share Posted July 8, 2013 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 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Nathan323 Posted July 10, 2013 Author Share Posted July 10, 2013 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.. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now