Run Excel Macro from Outside Excel Using VBScript From Command Line

by

Ok, it’s actually simple. Assuming that your macro is in a module,not in one of the sheets, you use:

  objExcel.Application.Run "test.xls!dog" 
  'notice the format of 'workbook name'!macro

For a filename with spaces, encase the filename with quotes.

If you’ve placed the macro under a sheet, say sheet1, just assume sheet1 owns the function, which it does.

    objExcel.Application.Run "'test 2.xls'!sheet1.dog"

Notice: You don’t need the macro.testfunction notation you’ve been using.

More Related Contents:

  1. Way to run Excel macros from command line or batch file?
  2. How to set recurring schedule for xlsm file using Windows Task Scheduler
  3. Export each sheet to a separate csv file
  4. Code for looping through all excel files in a specified folder, and pulling data from specific cells
  5. Bad data selection using VBScript , on date field values
  6. VBA comma separated cells, needt last entry only
  7. Are there disadvantages in putting code into Userforms instead of modules?
  8. Difference between ‘on error goto 0’ and ‘on error goto -1’ — VBA
  9. Excel: How to check if a cell is empty with VBA? [duplicate]
  10. ShowAllData method of Worksheet class failed
  11. Assign keyboard shortcut to run procedure
  12. Uncheck all checkboxes across entire workbook via CommandButton
  13. return csv file as recordset
  14. VBA workbooks.Close without being prompted to if the user wants to save?
  15. Excel macro -Split comma separated entries to new rows [duplicate]
  16. Get text from clipboard using GetText – avoid error on empty clipboard
  17. Copy a selected range to another worksheet
  18. Benchmarking VBA Code
  19. Excel macro – paste only non empty cells from one sheet to another
  20. The MacScript function is not working well in Office for Mac 2016! Any ideas?
  21. Display milliseconds in Excel
  22. VBA editor auto-deletes spaces at the ends of lines
  23. Application.Quit command not closing the entire Excel Application
  24. Trying to open the workbook in separate instance
  25. Convert Early Binding VBA to Late Binding VBA : Excel to Outlook Contacts
  26. Excel VBA – select multiple columns not in sequential order
  27. How to check whether certain sheets exist or not in Excel-VBA? [duplicate]
  28. Excel – Using COUNTIF/COUNTIFS across multiple sheets/same column
  29. Call a Unix Script from Excel Vba
  30. Delete all data rows from an Excel table (apart from the first)

Leave a Comment