use vba to run a windows scheduled task

  • Thread starter Thread starter ddbartley
  • Start date Start date
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
 
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
 
I'm trying to find vba code to run a windows scheduled task. Any ideas?
Click to expand...

If you're on XP go to All Programs->Accessories->System Tools-
Scheduled Tasks .
Click to expand...

You can run Excel.exe, a VBScript, a BAT script, or whatever from
there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scheduling task to run for Excel Addin 1
Schedule downloads in VBA 5
Task Scheduler or VBA to simple copy periodically folders contents toexternal drive 1
automatically trying to run a macro at a certain time 0
Schedule downloads 1
automatically trying to run a macro at a certain time 1
Update Links, Scheduled Tasks and UDFs 2
Scheduled task method of opening Excel questions. 1

Back
Top