Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use XL as packet sniffer & log?
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 |