| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Place a SHELL Window
I don't have an answer, but maybe an alternative at your other post.
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Place a SHELL Window
-----Original Message----- I don't have an answer, but maybe an alternative at your other post. Thanks. I have responded there - it's not what I wanted, but thanks anyway Does anyone else have an answer ? Pretty please ? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Place a SHELL Window
How about another followup--at your first post <vbg.
Robin Clay wrote: -----Original Message----- I don't have an answer, but maybe an alternative at your other post. Thanks. I have responded there - it's not what I wanted, but thanks anyway Does anyone else have an answer ? Pretty please ? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
| Macro to Split Window in Same Place Even If Columns Added or Hidde | Excel Discussion (Misc queries) | |||
| Running DOS .bat file from Shell in a small vs. full window | Excel Programming | |||
| Shell | Excel Programming | |||
| Closing DOS window after shell command | Excel Programming | |||
![Robin Clay[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
