running vb script on unix

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

running vb script on unix

Logged in as: Guest

arrSession:exec spGetSession 2,2,42341

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> running vb script on unix
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

running vb script on unix - 1/23/2007 12:12:38 AM

jacob23

Posts: 1
Score: 0
Joined: 1/23/2007
Status: offline

Hi,
I am new to vb scripting; in fact i am from a java background. I have a requirement whereby i need to execute the below mentioned vbscript through my java code ; also my application is deployed on a unix server.
The vbscript is as shown below -

My question is - will this script work on a unix server? If yes, what all should be installed / available on the unix server for this script to run?

Awaiting a prompt reply!!

Thanks and Regards,
Jacob

Post #: 1

RE: running vb script on unix - 1/23/2007 12:37:03 AM

SAPIENScripter

Posts: 276
Score: 2
Joined: 11/1/2006
From: SAPIEN Technologies
Status: offline

I don't see how this could run on a UNIX environment. First, it uses COM which I don't think is available on *.nix systems. More specifically it is using Microsoft Excel which would need to be installed on the server. Don't think I've ever seen Microsoft Office for Unix. On Unix you'd be better off using Perl, but that still won't help with the Excel piece.

_____________________________

Jeffery Hicks
Windows PowerShell MVP
SAPIEN Technologies - Scripting, Simplified. www.SAPIEN.com

Follow Me: http://www.twitter.com/JeffHicks

(in reply to jacob23)

Post #: 2

RE: running vb script on unix - 1/23/2007 12:38:35 AM

ebgreen

Posts: 5246
Score: 31
Joined: 7/12/2005
Status: offline

The only way that I could begin to conceive of running a vbscript to manipulate excel on a unix box would be to use WINE.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to SAPIENScripter)

Post #: 3

RE: running vb script on unix - 1/23/2007 1:42:39 AM

Parabellum

Posts: 222
Score: 0
Joined: 11/12/2006
From: UK
Status: offline

I think the only way of running anything VBS related on a unix system is through ASP
You can install Chillisoft which provides ASP support for *nix based systems (via a web server), but as for the Excel, I think thats very unlikely...
even if you get Excel to run using WINE i dont see how it would link the COM objects in the VBScript to Excel.. ??

(in reply to ebgreen)

Post #: 4

RE: running vb script on unix - 1/23/2007 1:58:53 AM

twilliamsen

Posts: 208
Score: 0
Joined: 1/18/2007
Status: offline

What about installing OpenOffice on the *NIX box? Then configure OpenOffice to save and create Excel Docs?

(in reply to Parabellum)

Post #: 5

RE: running vb script on unix - 1/23/2007 2:01:10 AM

ebgreen

Posts: 5246
Score: 31
Joined: 7/12/2005
Status: offline

That may or may not work depending on the contents of the excel spreadsheet.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to twilliamsen)

Post #: 6

RE: running vb script on unix - 1/23/2007 2:02:42 AM

twilliamsen

Posts: 208
Score: 0
Joined: 1/18/2007
Status: offline

Another solution:

Run PHP on the NIX and there is a prgram called BIFF Writer that will create excel spreadsheets via XML.

(in reply to ebgreen)

Post #: 7

RE: running vb script on unix - 1/23/2007 2:06:12 AM

ebgreen

Posts: 5246
Score: 31
Joined: 7/12/2005
Status: offline

I don't think that would work (and now that I think about it I wouldn't hold my breath on the Open Office solution either). The reason I don't think it will work is that the object of the script is to password protect the excel file. I have a feeling that password protecting the workbook is tightly integrated into the excel COM object which as was previously stated would not be available in native unix.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to twilliamsen)