use vba to run a windows scheduled task
 

I'm trying to find vba code to run a windows scheduled task. Any ideas?

use vba to run a windows scheduled task
 

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"), _
Procedu="my_Procedure", Schedule:=False



" wrote:

I'm trying to find vba code to run a windows scheduled task. Any ideas?

use vba to run a windows scheduled task
 

Here is a site for additional information on using the On Time method.

http://www.cpearson.com/excel/ontime.htm


" wrote:

I'm trying to find vba code to run a windows scheduled task. Any ideas?

use vba to run a windows scheduled task
 

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


wrote in message
oups.com...
I'm trying to find vba code to run a windows scheduled task. Any ideas?

use vba to run a windows scheduled task
 

On May 24, 7:22 am, wrote:
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.