How to launch a .cmd file from Excel (VBA)

[ericlbt]

Hello,

I am trying to launch a .cmd file from Excel (VBA).

Unfortunately, no matter what I try, nothing works.


I want to launch : control.cmd

Which is located in : \\Team2\Research\

Full path is: \\Team2\Research\control.cmd
Not on my C: drive


I played around with shell cmd.exe, the command, the path but never found the solution.


Any help will be much appreciated.
Thank you.

Eric

 

[GWteB]

Did you try this approach ...

Sub ericlbt()
    Dim oShell As Object
    Set oShell = WScript.CreateObject("WSCript.Shell")
    oShell.Run "cmd /C \\Team2\Research\control.cmd"
End Sub

 

[GWteB]

Please change the code of my previous post by deleting the Wscript. part:

Sub ericlbt()
    Dim oShell As Object
    Set oShell = WScript.CreateObject("WSCript.Shell")
    oShell.Run "cmd /C \\Team2\Research\control.cmd"
End Sub

 

[ericlbt]

Please change the code of my previous post by deleting the Wscript. part:

Sub ericlbt()
    Dim oShell As Object
    Set oShell = WScript.CreateObject("WSCript.Shell")
    oShell.Run "cmd /C \\Team2\Research\control.cmd"
End Sub

Hello GWteB,

Thank you for your quick reply.

It does not work: Permission denied (Error 70)

I guess I don't have access to the "Team2" drive.

I will check with my colleague and will let you know what happens.

 

[ericlbt]

Hello GWteB,

Thank you for your quick reply.

It does not work: Permission denied (Error 70)

I guess I don't have access to the "Team2" drive.

I will check with my colleague and will let you know what happens.

I guess there is no access issue as I can execute the command when I use a shortcut on my desktop.

 

[GWteB]

I guess there is no access issue as I can execute the command when I use a shortcut on my desktop.

In a network environment you can't be sure about that, since there's most likely a "network workspace manager" active which often imposes certain restrictions on the user.