I don't know a way of positioning the DOS window, but you could stop it from
closing:
Shell Environ("comspec") & " /k c:\runner.bat", vbNormalFocus
/c (instead of /k) will close the window
Robin Clay wrote:
Greetings !
I currently have this-
--------------------------------------------
Open "C:\Runner.bat" For Output As #1
Print #1, "@ECHO off"
Print #1, "Echo Please wait -"
Print #1, "Echo This may take some time ...."
Print #1, " [ other DOS commands ] ."
Close
Shell "C:\Runner.bat", vbNormalFocus
MsgBox "Please wait " & vbCrLf & _
"until the DOS window closes."
Kill "C:\Runner.bat"
----------------------------------------------
The reason for the MsgBox
is to prevent VBA from KILLing the batch file
until it has completed running.
I would like the DOS window to cover the MsgBox.
How can I specify whereabouts on the screen
the DOS window will appear?
RClay AT haswell DOT com
--
Dave Peterson