SyntaxFix

[excel] How do you run a .exe with parameters using vba's shell()?

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.

Examples related to excel

• Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support • Converting unix time into date-time via excel • How to increment a letter N times per iteration and store in an array? • 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) • How to import an Excel file into SQL Server? • Copy filtered data to another sheet using VBA • Better way to find last used row • Could pandas use column as index? • Check if a value is in an array or not with Excel VBA • How to sort dates from Oldest to Newest in Excel?

Examples related to vba

• Copy filtered data to another sheet using VBA • Better way to find last used row • Check if a value is in an array or not with Excel VBA • Creating an Array from a Range in VBA • Excel: macro to export worksheet as CSV file without leaving my current Excel sheet • VBA: Convert Text to Number • What's the difference between "end" and "exit sub" in VBA? • Rename Excel Sheet with VBA Macro • Extract Data from PDF and Add to Worksheet • Quicker way to get all unique values of a column in VBA?

Examples related to shell

• Comparing a variable with a string python not working when redirecting from bash script • Get first line of a shell command's output • How to run shell script file using nodejs? • Run bash command on jenkins pipeline • Way to create multiline comments in Bash? • How to do multiline shell script in Ansible • How to check if a file exists in a shell script • How to check if an environment variable exists and get its value? • Curl to return http status code along with the response • docker entrypoint running bash script gets "permission denied"

Examples related to parameters

• Stored procedure with default parameters • AngularJS ui router passing data between states without URL • C#: HttpClient with POST parameters • HTTP Request in Swift with POST method • In Swift how to call method with parameters on GCD main thread? • How to pass parameters to maven build using pom.xml? • Default Values to Stored Procedure in Oracle • How do you run a .exe with parameters using vba's shell()? • How to set table name in dynamic SQL query? • How to pass parameters or arguments into a gradle task

Examples related to command-line-arguments

• How to pass arguments to Shell Script through docker run • How can I pass variable to ansible playbook in the command line? • Use Robocopy to copy only changed files? • mkdir's "-p" option • What is Robocopy's "restartable" option? • How do you run a .exe with parameters using vba's shell()? • Bash command line and input limit • Check number of arguments passed to a Bash script • Parsing boolean values with argparse • Import SQL file by command line in Windows 7