vba - How can you run an Excel macro through a schedule task

Question

I need to run a macro in an Excel spreadsheet through a schedule task. I've defined the job as below:

"C:Program FilesMicrosoft OfficeOffice10EXCEL.EXE" ""

The problem is that when the job starts Excel displays a pop-up and asks if we want to disable/enable the macros, which blocks the execution of the job.

How can I run this macro without having to manually click on enable macro?

Answer 1

Write a short vbscript which launches Excel, loads your workbook and uses Application.Run to run the macro. Have your scheduled task run the vbscript.

Eg: http://www.mrexcel.com/forum/showthread.php?t=302970