Run macro with Windows Task Scheduler

[Noz2k]

Currently I have a task setup which opens my workbook every day at a set time, runs 2 macros in the workbook open procedure and then closes excel.

However as the macros email people, having the code run on the workbook open procedure is not ideal. If the file is opened at any other time these emails will still be sent, which will just confuse people (it also makes it a pain to edit as the procedure closes the workbook.)

Is there a way to use the task scheduler to run specific Macros so I wouldn't have to have them in the workbook open procedure?

 

[rcharters]

Running Excel 2007, OS = Vista
Create a .vbs file and run from Task Manager

Dim oExcel
Set oExcel = WScript.CreateObject("Excel.Application")
oExcel.Visible = True
oExcel.Workbooks.Open "C:\MyPath\MyProgram.xlsm"
oExcel.Run "'MyProgram.xlsm'!Main"
oExcel.workbooks("MyProgram.xlsm").Close False
oExcel.Quit
Set oExcel = Nothing