View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default Excel/Visual Basic

Probably because the time gets reset to 0 at midnight. Are you using an OnTime
macro for this? If not, you could try it. With that approach, the last line of
the macro typically sets up the next run, at a specific time. That time can
include a date. That would take care of the midnight problem.

On Tue, 12 Oct 2004 06:51:04 -0700, "MikeS"
wrote:

I am using the "timer function" in a macro to re-run a web query after a set
amount of time. I use this to update weather information and the current
company stock price for a "Video Bulletin Board". The problem is, the macro
aborts every night at 11:59. Can anyone tell me why this is happening and
how to fix it?

Thanks in advance.