View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
GPDynamics GPDynamics is offline
external usenet poster
 
Posts: 4
Default running two separate commands in same Shell

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" wrote:

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