Wait in VB

[crackdjack]

Hi All,

I am looking for a wait function in VB. To tell you some details, I am using VB functions for MS EXcel to run some automated scripts. Now, I want a function in VB which would WAIT(time) for the time specified. Anyone has any idea, how can I use that??

[Xiphias3]

What kind of "WAIT"?
Complete Freeze or Semi-Freeze.

Complete Freeze:

Private Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)
 
Ex; Call Sleep(1000) ' Freeze app for 1 second. Makes the app unresponsive

Semi-Freeze
Looping while Processing Message pump for messages like Redraw, Click, etc

Do While (bSuccess == False)
    DoEvents ' Readraw Form, respond to clicks, etc
Loop

[crackdjack]

What kind of "WAIT"?
Complete Freeze or Semi-Freeze.

Complete Freeze:

Private Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)
 
Ex; Call Sleep(1000) ' Freeze app for 1 second. Makes the app unresponsive

Semi-Freeze
Looping while Processing Message pump for messages like Redraw, Click, etc

Do While (bSuccess == False)
    DoEvents ' Readraw Form, respond to clicks, etc
Loop

I think, I would need a complete freeze. As, I want my execution to stop for a specified amount of time, and the begin again.
So, the complete freeze u mentioned would allow me to specifiy the amount of time?
Thanx a lot :-)

[Xiphias3]

The Sleep function takes 1 argument, time in milliseconds.
1000 = 1 Second

Call Sleep(5000) ' Sleep for 5 seconds

[crackdjack]

The Sleep function takes 1 argument, time in milliseconds.
1000 = 1 Second

Call Sleep(5000) ' Sleep for 5 seconds

Cool, thats good. Let me check out whether it satisfies my issue. Thanx.!! have a nice day.

[Xiphias3]

Just remember, the app becomes unresponsive with Sleep(). if you're gonna use it, place a DoEvents after the Sleep() so the application can process the pending events like Redraw.

[crackdjack]

Just remember, the app becomes unresponsive with Sleep(). if you're gonna use it, place a DoEvents after the Sleep() so the application can process the pending events like Redraw.

Yeah Ok, need to do that !!

[CDRIVE]

The Sleep API should be avoided like the plague unless you use it in minuscule slices. Here's how I use it. The example shows how it's called.

http://www.vbforums.com/showpost.php...12&postcount=8

[ZenDisaster]

If you're going to use a busy waiting loop, use the one in the link provided by CDRIVE as it is not as likely to turn your processor into molten silicon.