SyntaxFix

[vba] Execute a command in command prompt using excel VBA

The S parameter does not do anything on its own.

/S      Modifies the treatment of string after /C or /K (see below) 
/C      Carries out the command specified by string and then terminates  
/K      Carries out the command specified by string but remains

Try something like this instead

Call Shell("cmd.exe /S /K" & "perl a.pl c:\temp", vbNormalFocus)

You may not even need to add "cmd.exe" to this command unless you want a command window to open up when this is run. Shell should execute the command on its own.

Shell("perl a.pl c:\temp")



-Edit-
To wait for the command to finish you will have to do something like @Nate Hekman shows in his answer here

Dim wsh As Object
Set wsh = VBA.CreateObject("WScript.Shell")
Dim waitOnReturn As Boolean: waitOnReturn = True
Dim windowStyle As Integer: windowStyle = 1

wsh.Run "cmd.exe /S /C perl a.pl c:\temp", windowStyle, waitOnReturn

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 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 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 command-line

• Git is not working after macOS Update (xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools) • Flutter command not found • Angular - ng: command not found • how to run python files in windows command prompt? • How to run .NET Core console app from the command line • Copy Paste in Bash on Ubuntu on Windows • How to find which version of TensorFlow is installed in my system? • How to install JQ on Mac by command-line? • Python not working in the command line of git bash • Run function in script from command line (Node JS)