VBA equivalent for WScript.Sleep

[Guest]

Hi,

I need to pause my code periodically. When I use Application.Wait or Timer
function, the processor usage goes to about 50% all the time the sub is
paused, but I need something like WScript.Sleep from VBScript that will pause
execution without affecting processor usage.
Any help is appreciated.

 

[Guest]

You can use ontime

Sub Main
Your code here
Application.OnTime Now() + 0.000694444 , "NextPart"
End Sub

Sub NextPart
Rest of code here
End Sub

The 0.000694444 = 1 minute

 

[Dave Peterson]

There's a Sleep API, too:

Private Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)
Sub testme()
sleep 500 'half second
end sub

 

[Guest]

Thanks guys

--
urkec

There's a Sleep API, too:

Private Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)
Sub testme()
sleep 500 'half second
end sub