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
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