Auto kill a prosedure after a certain time

[AadVissers]

Hi there,

I have a macro which auto runs via windows sheduler. There are a couple of loops in the macro. Is it possible to automatically stop / kill the macro whem by accident an infinite loop takes place? This hasn't happend yet, but just to be sure. For example, stop running when it runs for more then ten minutes.

If this is possible, what code shoud I use?

Thank you!!

Adrian

[ARowbot]

You could make it take note of the time at the start of the code and then put in the condition of the loops something like:

Please Login or Register  to view this content.

[shg]

1. Put a DoEvents statement someplace where it executes often enough. After that statement, test a Boolean variable (like "bStop") to see if you should quit.

2. Before the routine starts, use OnTime to schedule a routine that sets bStop True. That routine could also be triggered by pressing a button.

The DoEvents statement will also make the code responsive to Ctrl+Break