Thread: 2 Timers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default 2 Timers

Hi Al

I'd put a "what time is is ?" check into the 30 sec loop and have that one
call the once-an-hour-procedure at the right time. But you provide too
little detail to make me say "That's the very best solution" ;-)

HTH. Best wishes Harald


"Al" skrev i melding
...
I have code that runs every 30 second to update a file. I have another

macro
that I need to run at 15 minutes after the hour to update another file.

What
is the best approach to accomplish this?
Thanks for the help!
Al