aiter

Excel stops responding

6 posts in this topic

#1 ·  Posted (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 by aiter

Share this post


Link to post
Share on other sites



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 (2016-08-18 - Version 1.4.6.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2016-12-04 - Version 1.2.2.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
Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

I use the excel UDF.

Share this post


Link to post
Share on other sites

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 (2016-08-18 - Version 1.4.6.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2016-12-04 - Version 1.2.2.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
Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Its the new UDF.  Thanks for your answers anyway,

Share this post


Link to post
Share on other sites

DoEvents seems to be a Visual Basic function. Do not know of an equivalent in AutoIt.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (2016-08-18 - Version 1.4.6.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2016-12-04 - Version 1.2.2.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
Tutorials:
ADO - Wiki

 

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