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