Call terminal from VBA (Linux)

Asked Jan 14 '16 at 21:14

Active Jan 14 '16 at 21:14

Viewed 330 times

I'm trying to run a script from Excel in Linux- is this possible? I used playonlinux to setup MS Office on Linux and tried the following simple code (originally from Execute a command in command prompt using excel VBA):

Dim wsh As Object
Set wsh = VBA.CreateObject("WScript.Shell")
wsh.Run "cmd.exe /c Z:/home/(me)/Downloads/test.sh"

but I get an Error 13: Type Mismatch. Any ideas? Thanks!

edited May 23 '17 at 11:59

Community

asked Jan 14 '16 at 21:14

rselvak6

Where do you get the type mismatch exception? – Matteo NNZ Jan 14 '16 at 21:38
On the last line- even the line `wsh.Run "cmd.exe"` throws the error. – rselvak6 Jan 14 '16 at 21:55

Call terminal from VBA (Linux)

0 Answers0