View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robin Clay[_3_] Robin Clay[_3_] is offline
external usenet poster
 
Posts: 55
Default Place a SHELL Window

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