Is it possible to run a VBScript in UNIX environment?

unix vbscript scripting scheduling execution
arunpandiyarajhen picture arunpandiyarajhen · Dec 2, 2013 · Viewed 34.7k times · Source

I've a Vbscript for merging excel sheet into a single workbook. I would like to know whether we could execute vbscript (.vbs) file in unix system. If yes, please help me with the procedures. Thanks in advance.

Answer

rutsky picture rutsky · Jun 5, 2014

Not sure about Unices, but on GNU/Linux it is possible to run VBScript using Wine, but VBScript support is limited.

On Debian/Ubuntu you can install as follows:

$ sudo apt-get install wine 
...
$

To run from command line:

$ wine cscript some-script.vbs

or 

$ wine wscript some-script.vbs

For example I can run following script using Wine 1.7.19 from Ubuntu Wine PPA:

' test.vbs

'WScript.Echo "Echo test"  ' doesn't work

'MsgBox "Message box!"     ' look like doesn't work either

' Write to file - works
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.CreateTextFile("out.txt", True)
objFile.Write "Output to file test" & vbCrLf
objFile.Close

run:

$ wine cscript test.vbs
fixme:vbscript:VBScript_SetScriptState unimplemented SCRIPTSTATE_INITIALIZED
fixme:scrrun:textstream_Close (0x13e208): stub
$ cat out.txt
Output to file test
$

Related questions

How can I check if a directory exists in a Bash shell script?

What command can be used to check if a directory exists or not, within a Bash shell script?

Read More
Looping through the content of a file in Bash

How do I iterate through each line of a text file with Bash? With this script: echo "Start!" for p in (peptides.txt) do echo "${p}" done I get this output on the screen: Start! ./runPep.sh: line 3: syntax error …

Read More
How to permanently set $PATH on Linux/Unix?

I'm trying to add a directory to my path so it will always be in my Linux path. I've tried: export PATH=$PATH:/path/to/dir This works, however each time I exit the terminal and start a new terminal …

Read More