View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default running two separate commands in same Shell

I think I'd just wait for each to finish:

http://support.microsoft.com/?kbid=214248
XL2000: How to Force Macro Code to Wait for Outside Procedure

or

Here's a link to a nice ShellAndWait function that does that.
http://groups.google.com/groups?thre...%40tkmsftngp03

===
Any chance you could build a new .bat file that does all the work and then just
call that?

GPDynamics wrote:

Hello,

Does anyone know how I could use the Shell command to open a Command Prompt
window and change title (Title Process1) to the window and then proceed to
run a program or batch file. I know how to do each separately but not
together.

I have a series of batch files/commands I want to loop through. By naming
the window I would know where they are in the loop.

Thanks for your assistance in this regard.

Michael D. Newby


--

Dave Peterson