| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time delay refresh on random number | Excel Worksheet Functions | |||
| Time Delay for Macros | Excel Discussion (Misc queries) | |||
| Time Delay in VBA | Excel Programming | |||
| Copy/Time Delay | Excel Programming | |||
| Time Delay | Excel Programming | |||
![quartz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
