Call a Macro from Command Line

[mcgowan.b]

Hi

I have a macro in a workbook that I want to kick off from a batch file

I can use the on workbook open command, but that would mean that i would have to call the macro every time I open the file myself too, which I don't want to do as I would have to modifiy the file occasionally

Is there a way to call a specific macro from a file in command line?

Something like C:\test\text.xls {test_macro}

Thanks

[Chippy]

You could do it with a VBScript (.vbs) file which you call from your batch file. This example allows the workbook to be specified as a command line argument for a bit more flexibility.

Save this as Run_Excel_Macro.vbs:

Dim args, objExcel

Set args = WScript.Arguments
Set objExcel = CreateObject("Excel.Application")

objExcel.Workbooks.Open args(0)
objExcel.Visible = True

objExcel.Run "Name_of_macro_in_workbook"

objExcel.ActiveWorkbook.Save
objExcel.ActiveWorkbook.Close(0)
objExcel.Quit

Call it from the command line or your batch file like this:

Run_Excel_Macro.vbs "C:\Full\Path\To\Your_Excel_Workbook.xls"