aiter Posted November 2, 2016 Share Posted November 2, 2016 (edited) I have a compiled console script that opens up an excel worksheet and does a lot of processing on it. The application (Excel) hangs and I get a dialog 'the application has stopped working....CLose, debug etc" I think the problem is I somehow I need to tell windows that the excel app is not hanging and let it remain open while the scripts is working on it (adding rows etc). I have a url that sums up the problem I am facing http://excelribbon.tips.net/T013341_Macro_while_Running_Stops_Excel_from_Responding.html The link mentions DoEvents and I do not know how to trigger this from my script. I have tried the sleep command in my script, but it does not seem to be adequate. I would appreciate any help. Edited November 2, 2016 by aiter Link to comment Share on other sites More sharing options...
water Posted November 2, 2016 Share Posted November 2, 2016 19 minutes ago, aiter said: does a lot of processing on it. Do you mean you run a VBA macro or that you do the processing from AutoIt by using the EXCEL UDF? 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...
aiter Posted November 2, 2016 Author Share Posted November 2, 2016 I use the excel UDF. Link to comment Share on other sites More sharing options...
water Posted November 2, 2016 Share Posted November 2, 2016 Did you use the old Excel UDF (pre AutoIt 3.3.12.0) or the fully rewritten UDF that came with AutoIt 3.3.12.0. There have been dramatic performance improvements in version 3.3.12.0. So maybe it's time for a rewrite of your script? 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...
aiter Posted November 2, 2016 Author Share Posted November 2, 2016 Its the new UDF. Thanks for your answers anyway, Link to comment Share on other sites More sharing options...
water Posted November 2, 2016 Share Posted November 2, 2016 DoEvents seems to be a Visual Basic function. Do not know of an equivalent in 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...
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