I am running a Visual Basic script in Visual Basic for Applications, from an Access database. I want to execute a shell script on a UNIX box from my VB code, test to see if it executed correctly, and then ftp the output files to my Windows box if the execution was successful.
Right now I am able to telnet to the UNIX box from my VB code, use SendKeys to execute the shell script, but I
1) can't tell if it executed successfully
2) am not sure how to then ftp the output files back
Would it be possible to get some sample code for this? Thanks.