View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Tracking OnTime Events?

Tushar answered you question.

If you are repeating the same routine, you might use Chip Pearson's method
as shown at

http://www.cpearson.com/excel/ontime.htm

this way you only have one pending event.

Since you ask "what they are", it would suggest you have many. You might
generalize the above approach and save the "Next event time and type"
information in a static array for each individual type.

--
Regards,
Tom Ogilvy

"M. Authement" wrote in message
...
Is there a way see if any OnTime events are pending, along with what they
are and/or what time they are scheduled to run?