Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a simple routine that schedules several subroutines to run durin the
day. Sub aaatest99() Application.OnTime TimeValue("07:59:50"), "aaaget800val" Application.OnTime TimeValue("08:59:50"), "aaaget900val" Application.OnTime TimeValue("09:59:50"), "aaaget1000val" end sub If I open excel, and run this routine. Then close excel, and re-open excel and re-run this routine... it appears that the subroutines are scheduled to run again, at the specified times. So that they will run twice, ie. the sceduled running of the subroutine was not cancelled when I closed excel. How exactly does Application.OnTime work? thanks, Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.ontime from shared drive | Excel Discussion (Misc queries) | |||
OnTime Unusual Application | Excel Programming | |||
Application.OnTime driving me crazy | Excel Programming | |||
Application.OnTIme | Excel Programming | |||
Application.OnTime and Visual C++ | Excel Programming |