Sending "Enter" command to cmd.exe app...
Mr. Rech,
You inspired a solution. The .BAT file that I was using
is on a network and is used by many others. Their needs
are different and therefore the file required a PAUSE for
user input and then executed the exit command. I simply
created my own .BAT file that does not need to PAUSE for
user input. Thank you for your help. It is much
appreciated.
Thanks,
Trevor
-----Original Message-----
If you add Exit as the last line of your batch file, does
it close the
window?
--
Jim Rech
Excel MVP
"Trevor" wrote in
message
...
| Hi all,
|
| I have written ( with much help from the message
board ) a
| macro in excel that opens a .BAT file, runs it, then
| continues with the import of a text file. However, when
| all is done, there is still a cmd.exe window left open
in
| the background waiting for "Press any key to
| continue...". When any key is pressed within that app,
| the app window is closed. Is there a way to send a
| command from the excel macro to that app to close it?
Any
| help is much appreciated.
|
| Thanks,
|
| Trevor
.
|