Hi,

Has anyone used VisualCron to schedule Excel macros? Sometimes Excel hangs on a popup or error state. EG if I accidentally leave a "MSGBOX" in my code, Excel may stop and wait for me to press "OK" before the macro continues. Alternatively if it errors out while downloading some data it might pop up an error box.

On a scheduled task which runs unattended, this is obviously problematic. Is there any way to kill Excel dead after waiting a certain amount of time for it to finish? Does it matter what type of artifact is on the screen when you try and kill it? eg a Msgbox or an error notification?

You could use the Kill Task and set it to kill the most recent excel process. I think that is the closest we can get to finding it.

---

You could also consider adding this line in you vba code:

Application.DisplayAlerts = False