"Application OnTime" Questions

[Cyberdude]

You don't have to leave Excel open (i dont think) as it will open it at that time and run the macro, of course it will not close it again unless you state it to! -- Simon Lloyd

I?ve never used the ?OnTime? thing. First of all, what is ?OnTime?? A function, a macro, another type of program?? Is it part of Windows or Excel or VBA??

Simon confused me (in his reply to griffism) by suggesting that Excel doesn?t have to be open for ?OnTime? to work. If the computer is on, but Excel isn?t, then what keeps ?OnTime? working?? That?s why I thought maybe it?s a child of Windows.

[rory]

OnTime is a method of the Excel Application object. It will run a scheduled macro if Excel is still open - the workbook containing the macro will be opened if required. If Excel has been closed, then the macro will not run - closing Excel clears the schedule.

[Paul_Hossler]

BTW, Windows has a AT command that can be use to run apps.

Online help:

The AT command schedules commands and programs to run on a computer at
a specified time and date. The Schedule service must be running to use
the AT command.

AT [\\computername] [ [id] [/DELETE] | /DELETE [/YES]]
AT [\\computername] time [/INTERACTIVE]
[ /EVERY:date[,...] | /NEXT:date[,...]] "command"
\\computername Specifies a remote computer. Commands are scheduled on the
local computer if this parameter is omitted.
id Is an identification number assigned to a scheduled
command.
/delete Cancels a scheduled command. If id is omitted, all the
scheduled commands on the computer are canceled.
/yes Used with cancel all jobs command when no further
confirmation is desired.
time Specifies the time when command is to run.
/interactive Allows the job to interact with the desktop of the user
who is logged on at the time the job runs.
/every:date[,...] Runs the command on each specified day(s) of the week or
month. If date is omitted, the current day of the month
is assumed.
/next:date[,...] Runs the specified command on the next occurrence of the
day (for example, next Thursday). If date is omitted, the
current day of the month is assumed.
"command" Is the Windows NT command, or batch program to be run.