Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to WAIT in Excel without using 100% CPU?
When using the Application.Wait command in Excel, CPU utilization goes to
100% for the duration of the wait command. Is there a better way? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to WAIT in Excel without using 100% CPU?
Hello, Marc
you could split your macro into two procedures, the first of which consisting of everything ahead of your application.wait command and the second one consisting of everything after it. Then, in the first procedure you could use the application.ontime command to call the second procedure with a certain time delay. This may also require some modification concerning the declaration (validation) of variables, but other than the application.wait command it doesn't require much CPU utilization. Regards Ingolf |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
(keys,wait) excel | Excel Discussion (Misc queries) | |||
sendkeys(keys,wait) how do I use wait | Excel Discussion (Misc queries) | |||
Wait function in Excel 2000 Macro | Excel Discussion (Misc queries) | |||
When Excel wait for OLE action allow cancel so not have to end pr | Excel Discussion (Misc queries) | |||
How do I get an excel macro to stop at a cell & wait for imput? | Excel Discussion (Misc queries) |