Using VBA with a DOS window

  • Thread starter Thread starter Stu_H
  • Start date Start date
S

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
 
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?
|
|
| ---
| Message posted
|
 
Back
Top