Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interrupting a loop
I have a macro that loops and within the loop produces and
emails a variety of workbooks. The process can take 15-20 minutes. Is there a graceful way to interrupt the loop at a set interval other than pressing the escape key and hoping for the best. Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interrupting a loop
You could set a variable to Now before the loop starts, and then within the
loop check Now against that variable le, and if it exceeds a pre-set amount of time, terminate the loop. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Andrea" wrote in message ... I have a macro that loops and within the loop produces and emails a variety of workbooks. The process can take 15-20 minutes. Is there a graceful way to interrupt the loop at a set interval other than pressing the escape key and hoping for the best. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interrupting Calculation Iterations | Excel Discussion (Misc queries) | |||
Interrupting Calculation Iterations | Excel Worksheet Functions | |||
Interrupting A Worksheet Calculation | Excel Worksheet Functions | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming | |||
Interrupting an add line | Excel Programming |