/Shell/Bash/Vba run shell command with arguments

Vba run shell command with arguments

Sub ExecuteShell(path As String, ParamArray arg() As Variant)
    Dim element As Variant
    Dim cmd As String

    cmd = path & " " 'insert any pre-arguments charaters

    For Each element In arg
        cmd = cmd & element & ", "
    Next element

    'remove last comma
    cmd = Left(cmd, Len(cmd) - 2)

    Call Shell(cmd)

End Sub

Source: stackoverflow.com

Similar codes

0 vote273 views1 answer
Git checkout filename
Shell/Bash
63 votes325 views6 answers
React router installation
Shell/Bash
0 vote301 views1 answer
Start shell on rosetta 2
Shell/Bash
21 votes338 views4 answers
How to install nodemon in project
Shell/Bash
7 votes347 views2 answers
Linux format usb command line
Shell/Bash
0 vote356 views1 answer
Ubuntu install apache mod_version
Shell/Bash
0 vote314 views1 answer
Error couldn't install package pillow big sur
Shell/Bash
0 vote308 views1 answer
Git close private repo
Shell/Bash
2 votes325 views2 answers
Bash comment section to a file
Shell/Bash
0 vote322 views1 answer
How to upgrade package yarn global
Shell/Bash