Envoke Excel Macro from schedule task or .bat file

[sine8000]

Greetings, is there a way to envoke an excel .vba macro from a .bat file or schedule task?

Thanks!

 

[daverunt]

Hi,

I'm not sure if you can call a macro directly from a BAT file but you can open the Workbook.
I use this method to open a macro file in a trusted location so I don't have macro security issues.

start excel "C:\Documents and Settings\My Documents\My Macros\Test_Macros.xls"

If you use a Workbook_Open event then the macro can be called when the workbook opens.
That may or may not suit your requirements?