VBA sending/reading from a running program

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

I want to interact with a running program.

I am using VB6 equivalent of VBA (VBA Access).

I will run the program with the shell command

I want to be able to read in the program what the program outputs -
program prompts.

I want to be able to write to the program sometimes in response to the
prompts similar to the UNIX
'expect' package.

Can someone please tell me how I read the output of a running program
and how to send text to the program?

Would I have to append a vbCR to the text string sent to the program?

Would someone be able to give me a sample code or a web site I can
consult?

Is the shell command the best way to start the command?

Thanks.
.

Relevant Pages

  • Visual basic - running program interaction
    ... The program is putty - a secure UNIX signon. ... program prompts. ... Can someone please tell me how I read the output of a running program ... Is the shell command the best way to start the command? ...
    (microsoft.public.vb.general.discussion)
  • Re: VBA sending/reading from a running program
    ... I am using VB6 equivalent of VBA. ... I want to be able to read in the program what the program outputs - ... program prompts. ... Is the shell command the best way to start the command? ...
    (microsoft.public.vb.general.discussion)
  • Shell command to post to notepad
    ... I want to paste some information to note pad from excel ... in vba I do something like ... I need something in the Shell command to make the notepad window active, ...
    (microsoft.public.excel.programming)
  • Creating a new message in OE through access
    ... I'm new to VBA. ... the features are sending an email. ... All I managed to do was to open OE with the shell command. ...
    (microsoft.public.outlook.program_vba)
  • FTP.exe
    ... Can anyone explain why an FTP.exe script works manually but will not work ... under a shell command in VBA? ... Prev by Date: ...
    (microsoft.public.windowsxp.basics)