Has it finished Calculating ????

[NevG]

Hi gang

Can somebody please tell me how I can make my VB app aware of the fact that the calculation behind the macro I have just run has finished or not.

I need to wait for this task to finihs before moving on but cannot figure it out yet.

i'm thinking maybe calciterations or something.

Sample code would be most appreciated.

Thanx for any help

Nev

 

[DaleWatson]

As one with substantial macro programming experience, but little VB experience, my solution might not be ideal; however, the solution appears to me to be simple:

Step 1 - Add to your macro, a simple command like "{LET variable1,1}" at the end of your calculation procedure. (you would have to initialize variable1 to "0" at the start of the macro).

Step 2 - In VB, simply insert a line which checks for the value in variable1.

Hope this helps. ...Regards ...Dale Watson