Way to run Excel macros from command line or batch file

Question

When accessing the file from a batch file, but not every time I open it, I need to run an Excel VBA macro (hence not using the open file event). Is it possible to execute the macro from a batch file or command line? I've never heard of such a command.

Any help would be appreciated.

Answer 1

• Open the workbook and run the macro from a VBScript file.
• Copy the code below into Notepad.
• Update the 'MyWorkbook.xls' and 'MyMacro' parameters.
• Save it with a VBS extension and run it.

Option Explicit

On Error Resume Next

ExcelMacroExample

Sub ExcelMacroExample() 

  Dim xlApp 
  Dim xlBook 

  Set xlApp = CreateObject("Excel.Application") 
  Set xlBook = xlApp.Workbooks.Open("C:\MyWorkbook.xls", 0, True) 
  xlApp.Run "MyMacro"
  xlApp.Quit 

  Set xlBook = Nothing 
  Set xlApp = Nothing 

End Sub 

The key line that runs the macro is:

xlApp.Run "MyMacro"