vba running too fast

[vzachin]

hi,
i'm currently using vba to manipulate data in extra but the code is running too quickly. is there any way to slow down my macro?

i added the following
Sess0.Screen.WaitHostQuiet (5000)
to my code but it doesn't help too much

thanks

 

[calculus]

You need to "look" for something on each screen change. the WaitForString method is very helpful.

Alternately you can use the OIA object to wait for the XClock to disappear.

Do while Sess0.screen.OIA.Xstatus <> 0
Doevents
Loop

calculus

 

[Skie]

You can also always do a wscript.sleep(integer) where integer is the number of miliseconds you want to wait.

 

[Dee0612]

I have used calculus' method in the past instead of the Sess0.Screen.WaitHostQuiet for some macros which I had similar probelms with and it worked great.

I usually do use the Sess0.Screen.WaitHostQuiet method but find some applications in extra a bit tempermental and require calculus' method!

 

[vzachin]

Thank you SO much !