Best way to pause?

  • Thread starter Thread starter Ramthebuffs
  • Start date Start date
R

Ramthebuffs

I am running a WinHttp.WinHttpRequest and would like to pause in between
loops. Currently I have Application.Wait Now + TimeSerial(0, 0, 5)
During the pause the CPU gets up to 100% and remains there until the
pause is done. Is there a better way to put a pause in a macro that is
less taxing on the CPU?
 
I've tried this but it seems to freeze in excel Application.OnTime Now
TimeSerial(0, 0, 5), "GetResults
 
the Ontime function does work, but it doesn't show screen updates or
allow me to work with excel when its running. Here is what I have with
Ontime Application.OnTime Now + TimeSerial(0, 0, 5), "GetResults"
Have I not entered it correctly or something? Is it freezing because
its set for a short period of time?
 
Back
Top