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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pause a macro by resetting current time 3
How to pause without being "modal" 1
Stop / Pause a Macro using Pause button 4
pausing macro while cells update 6
pausing vba for refresh 5
How to Pause an Excel VBA script without freezing excel 1
Funcitonality to pause macro?! 13
Pause a Macro 6

Back
Top