Situation: key pieces of data are transmitted from a server to software on
my PC (so I see the info within the program, but can't copy/paste it- it's
actually a DOS-based program, which I run full-screen on Win98SE). I want
to capture some key pieces of this data and put it in a log or inventory in
Excel2K, rather than manually copying the info down, and typing it all back
into excel.

I'm decent with VBA (although nowhere near a lot of you folks on this ng),
but I have no experience whatsoever with intercepting data streams (even
figuring out how to), and from that figuring out which pieces are the ones
I need (I'll figure that part out later I guess).

Best case would be:
I open Excel and start my VBA
I open the DOS program in the DOS shell, and just go look at the different
views (where the data are) to get it sent from the server
I go back to Excel and the info is logged (in as many rows as it takes)
Then I can write VBA to grab just the pieces of the strings that I need and
put it in some kind of order

Any pointers to sample programs, code snippets, or even just what keywords
I should be searching this newsgroup on to find out how to do this would be
greatly appreciated.

Many thanks,
Keith R