How best to use Application.OnTime?

[JeffGrant]

Hi All,

In my model, I have time critical macros to run.

There are four components, where the run time would be T=0, T= 2, T=5 & T=7 minutes.

With T=0 and T=7, I must run Application.OnTime because it involves download and uploading data to an API.

However, with T =2 & T= 5, I could just as easily achieve the result using the Application.Wait command inside a sub.

I don't know enough about the pitfalls of using Application.OnTime in bulk and how the memory is allocated/handled. I am literally scheduling anything up to 100 events give or take.


My question is: Am I better off to schedule everything with Application.OnTime or use a combination of Application.OnTime and Application.Wait?

Thanks for your help in advance.

 

[RoryA]

IMO it would be simpler to have the called routine schedule itself again as necessary.