Windows & DOS: Issues & Discussions

Hi

Can we pass the parameter from the excel in windows and invoke the unix shell script from excel VBA by passing this parameter and get the results of shell script to the excel sheet?

We tried to get the things in unix independently but we still strucked in connecting the excel to unix box.

Thanks in advance,
KVB

Please give us way more insight in your constellation, and what you are trying to do. Two different machines? Single machine with a virtual box on it? Or is it running cygwin?

It's on two different machines.

I know nothing of Excel, but, assuming that you can invoke a program with command line options, then, install Microsoft SFU (Services for Unix) and use rsh to run a command on the unix system.
SFU is a free download from Microsoft. Download Windows Services for UNIX Version 3.5 from Official Microsoft Download Center

A web server on UNIX would allow you to use excel to fetch the result. Parameters can be put in the URL, urlencoded GET style.

If you mount the directory between machines using NFS or SAMBA, Excel can save/import as CSV and UNIX can write/read the CSV files. Once we created a stock price app from a pc with excel and a stock price app and some VBA, where UNIX would list the stocks of interest every 15 minutes, VBA would respond with prices and the prices were loaded into the RDBMS for JAVA to do risk assessment.

In VBA, there is a system call, whose name temporarily escapes me, to run an external windows command. You could use that to e.g. telnet into the unix machine, run a script and harvest the result into a VBA variable, which then can be handed over to EXCEL.