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