Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ontime run at a particular time
Can anyone show me how to change this to run lets say at 10:30 am?
You may want to play with Application.OnTime Sub ScheduleMe() Application.OnTime Now() + TimeValue("00:00:05"), "RunMe" End Sub Sub RunMe() Beep ScheduleMe End Su -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ontime run at a particular time
Sub ScheduleMe()
Application.OnTime TimeValue("10:30 AM"), "RunMe" End Sub Sub RunMe() Beep 'ScheduleMe End Sub If you want each run to schedule another, then look at Chip Pearson's site http://www.cpearson.com/excel/ontime.htm -- Regards, Tom Ogilvy "Soonernut " wrote in message ... Can anyone show me how to change this to run lets say at 10:30 am? You may want to play with Application.OnTime Sub ScheduleMe() Application.OnTime Now() + TimeValue("00:00:05"), "RunMe" End Sub Sub RunMe() Beep ScheduleMe End Sub --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find %ontime & SUMIF ontime ie: find matching sets within Range... | Excel Worksheet Functions | |||
OnTime bug? | Excel Discussion (Misc queries) | |||
OnTime...Please Help | Excel Programming | |||
OnTime Help | Excel Programming | |||
OnTime method only runs 1 time | Excel Programming |