Determine when an outside process is finished 2

[JTBorton]

Excel 2007
I am using vb scripts to collect live data from a production unit. The information is then formatted into variables and scripts for a specific simulation program. I then call the simulation program to run an optimization case and return the optimized plant parameters. The optimized parameters are then pushed back out to the production unit.

So my question is: How can I determine when an outside program is completed? Can I set up an outside variable and pass the variable address?

-Joshua
Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. [M. Passman]

 

[SkipVought]

Hi,

Kill the output file before the final process runs.

Test for the existence of the output file while the final process runs. When it exists, the process is complete.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jges]

Does the script start the outside program? If not, can it?
If so, you can use the shell object's shell.run method to wait for the other process to end.

http://msdn.microsoft.com/en-us/library/d5fk67ky(VS.85).aspx

 

[JTBorton]

I think both answers very helpful. Stars for both of you. Thanks.

-Joshua
Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. [M. Passman]