Time delay function

[Guest]

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?

 

[Guest]

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?

 

[Guest]

What my program "does" is irrelevant to you since all I need is for the
program to fire at the appropriate time. All I need is a call to my sub once
the appropriate time arrives.

Can you post your example code?

 

[Guest]

well if you are going to be fuffy about it...
look up on time in help.

 

[Guest]

Nevermind. I figured it out myself.

well if you are going to be fuffy about it...
look up on time in help.