Ontime Method overloading the call stack.

[ions]

Dear Excel Expert.

I am trying to figure a way to run a procedure every 2 minutes.

I could call Ontime and have the triggered procedure have another embedded OnTime but won't this overload the Call Stack?

The result I am after is trying to Refresh an XML datasource every two minutes. If there is another way to do this your input would be much appreciated as well.

Thank you.

[Paul]

Hi ions,

To do this, you should have two macros. One to start the OnTime event and the other to perform the work.

The initial macro initiates the first OnTime event, i.e. to occur two minutes from now. In the second macro (the one called by the OnTime event) you could add a Call to the initial macro at the end (e.g. Call my_onTime_event, or Call init_Timer, etc.).

When OnTime runs for the first time and executes successfully, it is unloaded and should therefore not create any call stack problems (at least none that I've seen).

Hope that helps!

[ions]

Hmmm.... I would think this would create a stack overflow because the subroutines never reaches the statement end sub.

Control is never returend to the original subroutine call.