D
ddbartley
I'm trying to find vba code to run a windows scheduled task. Any ideas?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
This is right out of VBA help file.
This example runs my_Procedure at 5 P.M.:
Application.OnTime TimeValue("17:00:00"), "my_Procedure"
This example cancels the OnTime setting from the previous example.:
Application.OnTime EarliestTime:=TimeValue("17:00:00"), _
Procedure:="my_Procedure", Schedule:=False
This example runs my_Procedure at 5 P.M.:
Application.OnTime TimeValue("17:00:00"), "my_Procedure"
This example cancels the OnTime setting from the previous example.:
Application.OnTime EarliestTime:=TimeValue("17:00:00"), _
Procedure:="my_Procedure", Schedule:=False
G
Guest
Here is a site for additional information on using the On Time method.
http://www.cpearson.com/excel/ontime.htm
http://www.cpearson.com/excel/ontime.htm
R
RB Smissaert
See if you can find the file tskschd.dll from E Morgillo on the net if you
want to do more than just run a task.
RBS
want to do more than just run a task.
RBS
G
gimme_this_gimme_that
I'm trying to find vba code to run a windows scheduled task. Any ideas?
If you're on XP go to All Programs->Accessories->System Tools-
Scheduled Tasks .
You can run Excel.exe, a VBScript, a BAT script, or whatever from
there.