I want to call the a unix shell script present in the remote sever
using Visual Basic Application.
Is it possible to invoke the shell script present in the remote server
and get the output of the script in a Excel format.
Pls Throw some light to this question.
Thanks and Regds,
You may run a batch file from inside VB. The batch file in turn opens a telnet session with a server and calls the script. You can create an exclusive user in the unix box thro' which the telnet session will be logged in. The profile of this user will run the script on logging in. You may have to then copy (ftp?) the tab/comma separated file to the local machine and then to a Excel import through some OLE function.
I guess, its very complicated and hence would suggest you to try simpler means of achieving what you would want.