Sending "Enter" command to cmd.exe app...

[Trevor]

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

 

[Jim Rech]

If you add Exit as the last line of your batch file, does it close the
window?

--
Jim Rech
Excel MVP
| 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

 

[Guest]

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

 

[Tom Ogilvy]

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

=
Regards,
Tom Ogilvy