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:

Please Login or Register  to view this content.

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

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