View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Time delay function

hi,
there is the on time function. I use it to fire a macro at
five o'clock each morning skipping weekends.
but the on time event will only pause the macro unto the
designated time at which time it will want to do something
like run another macro.
your post is very specific about the time but real foggy
about what happens after the time arives.
"the program would not run until the date and time arrive."
what program? what does this program do?


-----Original Message-----
I need efficient code that would prompt the user to enter

a date and time.
This would need to be validated somehow.

The program would not run until the date and time arrive.

The time period
could span a weekend or holiday (thus the date included).

The format needs to be full date + time down to the

minute. The network or
system time is close enough.

Does anyone have such a function?
.