vba execute exe command line with 2 parameters

Question

I want to run an exe file from VBA with 2 parameters. To be more specific here is the exact line that works for me in command line (Win+R), I just need it in VBA:

C:\Program Files (x86)\MacroRecorder\MacroRecorder.exe "E:\test.mcr" /a

I tried so far:

Sub open_test_file()

Call Shell("C:\Program Files(x86)\MacroRecorder\MacroRecorder.exe 'E:\test.mcr' /a")

End Sub

And this:

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

    strProgramName = "C:\Program Files (x86)\MacroRecorder\MacroRecorder.exe"
    strArgument = "E:\test.mcr"
    strArgument2 = " /a"

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

What do you have thus far?

Tim Stack
– Tim Stack

2019-04-10 11:46:32 +00:00
Commented Apr 10, 2019 at 11:46 — Tim Stack
– Tim Stack, Commented Apr 10, 2019 at 11:46
I'll edit what i tried so far to the original question

Assaf
– Assaf

2019-04-10 12:33:09 +00:00
Commented Apr 10, 2019 at 12:33 — Assaf
– Assaf, Commented Apr 10, 2019 at 12:33

Harassed Dad · Accepted Answer · 2019-04-10 11:59:29Z

1

Shell "C:\Program Files (x86)\MacroRecorder\MacroRecorder.exe 'E:\test.mcr' /a"

Note speech marks and quotes

answered Apr 10, 2019 at 11:59

Harassed Dad

4,7141 gold badge12 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Assaf Over a year ago

it says File not found, Call Shell("C:\Program Files(x86)\MacroRecorder\MacroRecorder.exe 'E:\test.mcr' /a")

Collectives™ on Stack Overflow

vba execute exe command line with 2 parameters

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related