Excel Macro to launch remote command

[chester27]

Looking for help with creating a macro to launch a command or script on a remote server, and return success or fail.

 

[mintjulep]

How far away is the remote server?

 

[chester27]

100's of miles away. We only have RDp access, and is the only box with the application we want to call. I can do it using calls to batch files that use PsExec from Sysinternals, but this is not practical to place on 100's of PC's

Just looking for maybe a function to call and execute the command on the remote server, and have this controlled by a button on an excel spreadsheet.

 

[DjangMan]

You could use VBA to run the PsExec via command line.

From:

https://stackoverflow.com/questions/20917355/how-do-you-run-a-exe-with-parameters-using-vbas-shell

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