How do I write to a command prompt that is already open?

Question

I need to write one line at a time (user iterative process) to a command prompt that is already open.

I'd like to use VB or VBA. I know there is AppActivate, but then how do you write to it?

The command prompt is run by another program (that I can't touch).

Suggestions?

Answer 1

You can attach to an already open console window using the Windows API function AttachConsole (sample VB code).

Private Declare Function AttachConsole Lib "kernel32" (ByVal hConsoleHandle As Long) As Long

You can then write to STDOUT using this sample.