running two separate commands in same Shell

[Guest]

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]

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?threadm=ump2dlfcBHA.1656@tkmsftngp03

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

 

[Guest]

I do wait and check if process has finished bfore starting another. I just
want to be able to change the title of the Command Prompt windows before each
process starts. That way i know if I on process # x of n processes.

 

[Dave Peterson]

Maybe someone will chime in with a solution for you.

For me, I'd just change the statusbar:

application.statusbar = "Now doing step 8 of 18"

(And I think I'd keep the command window minimized or hidden)