How do you run a .exe with parameters using vba’s shell()?

by

This works for me (Excel 2013):

Public Sub StartExeWithArgument()
    Dim strProgramName As String
    Dim strArgument As String

    strProgramName = "C:\Program Files\Test\foobar.exe"
    strArgument = "/G"

    Call Shell("""" & strProgramName & """ """ & strArgument & """", vbNormalFocus)
End Sub

With inspiration from here https://stackoverflow.com/a/3448682.

More Related Contents:

  1. Wait for shell command to complete [duplicate]
  2. VBA Shell function in Office 2011 for Mac
  3. Sequence of numbers based on start and end value of 2 cells [closed]
  4. Better way to find last used row
  5. How to insert a picture into Excel at a specified cell position with VBA
  6. 2 Dimensional array from range [closed]
  7. Save multiple sheets to .pdf
  8. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  9. How can I create a calendar input in VBA Excel?
  10. Using Google Chrome in Selenium VBA (Installation Steps)
  11. Dir() function not working in Mac Excel 2011 VBA
  12. Merge values of column B based on common values on column A
  13. How to use workbook.saveas with automatic Overwrite
  14. How to import a table from web page (with “div class”) to excel?
  15. Range limit conundrum
  16. Concatenate cell data into another data if values matches
  17. Iterating through populated rows
  18. How to convert 32 bit VBA code into 64 bit VBA code
  19. Using VBA to detect which decimal sign the computer is using
  20. Loop through each row of a range in Excel
  21. Fill formula down till last row in column
  22. Outputting Excel rows to a series of text files
  23. How to create a range from two ranges in VBA?
  24. XML parse VBA excel (function trip, & MSXML2.DOMDocument)
  25. If string contains word from list, return value adjacent to list value
  26. every possible combination of the contents of 2 columns in excel
  27. excel vba freeze pane without select
  28. Converting a string representation of a constant into a constant?
  29. Function Overloading and UDF in Excel VBA
  30. VBA Excel simple Error Handling

Leave a Comment