Time delay function
 

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?

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

Time delay function
 

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?

" wrote:

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

Time delay function
 

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

-----Original Message-----
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?

" wrote:

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


.

Time delay function
 

Nevermind. I figured it out myself.

" wrote:

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

-----Original Message-----
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?

" wrote:

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


.