Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to pause?
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? -- Ramthebuffs ------------------------------------------------------------------------ Ramthebuffs's Profile: http://www.excelforum.com/member.php...o&userid=16429 View this thread: http://www.excelforum.com/showthread...hreadid=517610 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to pause?
I've tried this but it seems to freeze in excel Application.OnTime Now TimeSerial(0, 0, 5), "GetResults -- Ramthebuff ----------------------------------------------------------------------- Ramthebuffs's Profile: http://www.excelforum.com/member.php...fo&userid=1642 View this thread: http://www.excelforum.com/showthread.php?threadid=51761 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Best way to pause?
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? -- Ramthebuffs ------------------------------------------------------------------------ Ramthebuffs's Profile: http://www.excelforum.com/member.php...o&userid=16429 View this thread: http://www.excelforum.com/showthread...hreadid=517610 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pause a macro? | Excel Programming | |||
Pause | Excel Programming | |||
Pause? | Excel Programming | |||
Pause in execution | Excel Programming | |||
Pause a VBA Module | Excel Programming |