Execute a command in command prompt using excel VBA

by

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

More Related Contents:

  1. How do I get values from a hidden worksheet using VBA [closed]
  2. How to copy cells that contain certain text to another worksheet [closed]
  3. VBA Macro for copying and pasting columns on same excel sheet
  4. Excel VBA, code to count the # of filled cells, then find highest and 2nd highest and subtract the corresponding column #’s [closed]
  5. Get all dates between 2 dates in vba
  6. Levenshtein Distance in VBA [closed]
  7. Run Excel Macro from Outside Excel Using VBScript From Command Line
  8. VBA Shell function in Office 2011 for Mac
  9. Efficient way to delete entire row if cell doesn’t contain ‘@’ [duplicate]
  10. Building Undo Into an Excel VBA Macro
  11. Excel vba add code to sheet module programmatically
  12. Best workaround for VBA Transpose array length limit?
  13. How to Lock the data in a cell in excel using vba
  14. How to use Events with Option Button Controls on Userform [duplicate]
  15. How to send files via HTTP_POST with Excel using VBA?
  16. How do I use variables to set properties in VBA (Excel)
  17. VBA: Else without If Error
  18. VBA to open Excel hyperlink does not work when hyperlink generated with a formula
  19. Workbooks.Open Method in VBA
  20. Windows().Activate works on every computer except one
  21. How to highlight a cell using the hex color value within the cell?
  22. Convert RTF (Rich Text Format) code into plain text in Excel
  23. lastrow and excel table.
  24. Open a workbook from VBA and disable Workbook_Open() code?
  25. Creating form programmatically in the module using vba
  26. How to filter listbox values based on a Textbox value
  27. Find and FindNext for Excel VBA
  28. How to have vba execute every 10 minutes?
  29. Read and write from/to registry in VBA
  30. Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

Leave a Comment