Problem with Shell function runs other programs asynchronous

[barryt]

I have two shell commands right after each other

To make things simple lets say the old.txt is a static file that doesn’t change and is made already

The first shell with the old.txt info when it runs it makes the old2.txt
Shell "Command.com < old.txt" ‘This line runs and it makes old2.txt file
Shell "Command.com < old2.txt"

The Problem is excel run the command.com Then it runs the command.comBut the old2.txt hasn’t been made yet


What works kind of which I don’t want to use is putting this next couple statements between the two shell “command.com”
Making a for aloop = 1 to 10000000
Next a

What I want to do is change the default of the shell function to have it wait until the shell “command.com” is finished
I think I found on the msn some info on how to do it but I haven’t been able to find that info again
Or maybe if was for a different language
I tried what I remembered it said but I didn’t have any luck


This is some text from help in excel
Note By default, the Shell function runs other programs asynchronously. This means that a program started with Shell might not finish executing before the statements following the Shell function are executed.

Thanks
Barry

[Ivan F Moala]

Have a look here
http://www.mrexcel.com/board/viewtop...c=5236&forum=2

Look @ BrettVBA answer....this answer is more
suited to your needs.
Post if further help required.

[barryt]

Thanks
for pointing out BrettVBA answer

I quicky looked at his answer before but kind got confused with it
so i didn't understand what all it was doing
but since you pointed it out i read it closer and tried it and it looks like a good solution to my problem
Thanks
Barry
Also thanks to BrettVBA for posting his message and code