Hi there,

I apologize if this is not the right newsgroup but I might as well ask. At
my work place we have both Windows and Unix although there is no SAMBA
implementation to allow Unix to interact with a Microsoft Windows client or
server (vice versa).

What I want to do is create some Windows program/script (e.g. VBA based
script that will be executed from inside Excel) that would connect to 2
separate Unix accounts (with different login credentials for each account)
and execute a separate shell command on each Unix account.

Any suggestions what is the best way to achieve something like this?

Thanks
Michael

Sure.

If you're a Java shop and you know ANT ...

Have Excel VBA create an ANT properties file having data saved in
Excel.

Then call ANT from Excel just as you'd execute any shell command from
Excel.

ANT, as it turns out, when installed with the optional.jar, has easy to
use ftp tasks.

The script is easier to write if the commands can be executed
sequentially instead of simultaneously. If it has to be simultaneously,
you'll have to spon both processes from ANT rather than from Excel.


Michael wrote:
> Hi there,
>
> I apologize if this is not the right newsgroup but I might as well ask. At
> my work place we have both Windows and Unix although there is no SAMBA
> implementation to allow Unix to interact with a Microsoft Windows client or
> server (vice versa).
>
> What I want to do is create some Windows program/script (e.g. VBA based
> script that will be executed from inside Excel) that would connect to 2
> separate Unix accounts (with different login credentials for each account)
> and execute a separate shell command on each Unix account.
>
> Any suggestions what is the best way to achieve something like this?
>
> Thanks
> Michael