Execute commands on a Remote connection to Unix box

[GST]

Hi Guys,

I hope this is the correct forum.

I need some help on how to execute procedures on a remote
Unix machine.

Currently my users log into a Unix box and enter a command
that produces a “text” file.

I have successfully ftp’ed the text file, using VB , from the
Unix machine to a directory on my pc.

I hope you will help me figure out how, via VB , to:

1. Execute the command on the remote Unix machine
2. Wait until the command finishes


Thanks,

 

[Pat Hartman]

I'm sure you'll have better luck in a VB forum. We solve Access problems here.

 

[GST]

Pat,

Thanks for the reply, I reviewed my post and I can see how it
may be confusing.

It is in fact an Access database that is used for generation of
management reports from information (text files) generated on
a Unix box. Modules written in VBA are used behind the forms
and reports for any special processing.

Originally the user ran a procedure on the Unix box to generate
the text files. The text files were then FTP'ed from the Unix box
to the PC network. At that point the user imported the text files
into the Access database and produced the reports.

I have successfully provided forms which, when a button is
clicked, automatically FTP the text files from the Unix box to the
PC network, import the text files into the Access database, and
produce the required reports.

The last step in totally automating the process is the first step
in the original user process, running a procedure on the Unix box.

If I could find a way, via VBA, to:

1. Connect to the Unix box
2. Execute a process on the Unix box
3. Wait till the process is complete before continuing

then I could eliminate the requirement that my user log into the
Unix box in order to generate the required text files.

I was just wondering if there was anyone who has experience
connecting to a Unix box using VBA.

I have, and continue to search other forums trying to determine
a solution to my problem.

In this forum I was able to find references to a "winsock object"
and I was hoping those members could shine a little light on
that subject for me.

Once again thanks for the reply.

Gary

 

[Pat Hartman]

If you don't get any suggested code, you might try scheduling the procedure to run at a certain time of the day.