Way to run Excel macros from command line or batch file?

by

You can launch Excel, 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”

More Related Contents:

  1. Run Excel Macro from Outside Excel Using VBScript From Command Line
  2. Wait for shell command to complete [duplicate]
  3. MS Excel: insert a row automatically if the content in a cell is <> that in cell of the last row?
  4. vba excel: how to copy characters from a cell to another
  5. Microsoft Excel ActiveX Controls Disabled?
  6. What is the default scope of worksheets and cells and range?
  7. Convert an entire range to uppercase without looping through all the cells
  8. Convert Text to Date?
  9. Loop through each cell in a range of cells when given a Range object
  10. Checking for #N/A in Excel cell from VBA code
  11. Non-web SQL Injection
  12. Error: “Could Not Find Installable ISAM”
  13. Properly Handling Errors in VBA (Excel)
  14. Password hash function for Excel VBA
  15. Is there a way to slow down a Web Scraper so it will pick up the code?
  16. Create a folder and sub folder in Excel VBA
  17. Aggregate, Collate and Transpose rows into columns
  18. One-dimensional array from Excel Range
  19. Select method of Range class failed via VBA
  20. Renaming Files with Excel VBA
  21. Is there a way to import data from .csv to active excel sheet?
  22. Comparison of Dictionary, Collections and Arrays
  23. Break out of a While…Wend loop
  24. How to add events to dynamically created controls (buttons, listboxes) in Excel VBA userform
  25. How to make safe API Timers in VBA?
  26. EntireRow.Delete performance issue
  27. How to extract groups of numbers from a string in vba
  28. How to implement custom iterable class in VBA
  29. move files from one folder to another
  30. How to find Number of Occurences of Slash from a strings

Leave a Comment