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

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

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


.

Shell "cmd.exe /c c:\Myfile.Bat"

=
Regards,
Tom Ogilvy

"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