View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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?