Excel stops responding

[aiter]

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

[water]

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?

[aiter]

I use the excel UDF.

[water]

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?

[aiter]

Its the new UDF.  Thanks for your answers anyway,

[water]

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