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.
|