VBA equivalent for WScript.Sleep
 

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.



--
urkec

VBA equivalent for WScript.Sleep
 

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

"urkec" wrote:

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.



--
urkec

VBA equivalent for WScript.Sleep
 

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

urkec wrote:

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.

--
urkec

--

Dave Peterson

VBA equivalent for WScript.Sleep
 

Thanks guys

--
urkec


"Dave Peterson" wrote:

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

urkec wrote:

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.

--
urkec

--

Dave Peterson