Application.OnTime

Under ThisWorkbook section i have code:

Please Login or Register  to view this content.

The issue is that the sub RetrieveEssbase occurs three times (sub takes about 2.5 minutes to execute) without stopping until the time is after 12PM. . .

ah, am I missing something?

thanks

sportsguy

I found one reference to programmatically STOPPING the OnTime

http://www.cpearson.com/excel/OnTime.aspx