Using VBA with a DOS window

[Stu_H]

I am currently trying to develop a windows based shell, to run an ol
command line driven DOS progam. The idea is to use drop down menus et
to simplify the programs use.

I am using the keystrokes function to type in the commands so that th
window doesn't automatically close itself when it is finished. I wa
hoping that it could be possible to copy and paste the command promp
screen output, so that I can paste it (and hence use it) in Excel.

Does anyone have any idea as to how I can do this and/or links to an
websites that talk about working with DOS windows

 

[jaf]

Hi Stu,
STDOUT is what your looking for. Not much fun from VBA or VB.

If you really want to play. Here is a google search link where you find much help.
http://www.google.com/groups?as_q=s...=UTF-8&as_ugroup=*vb*&lr=lang_en&num=50&hl=en



--
John
johnf 202 at hotmail dot com


| I am currently trying to develop a windows based shell, to run an old
| command line driven DOS progam. The idea is to use drop down menus etc
| to simplify the programs use.
|
| I am using the keystrokes function to type in the commands so that the
| window doesn't automatically close itself when it is finished. I was
| hoping that it could be possible to copy and paste the command prompt
| screen output, so that I can paste it (and hence use it) in Excel.
|
| Does anyone have any idea as to how I can do this and/or links to any
| websites that talk about working with DOS windows?
|
|
| ---
|
|