Using VBA with a DOS window
 

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

--
Message posted from http://www.ExcelForum.com

Using VBA with a DOS window
 

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=st...n&num=50&hl=en



--
John
johnf 202 at hotmail dot com


"Stu_H " wrote in message ...
| 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?
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|