EXE in VB

[andrew299]

I have a exe file and a very large macro, is it possible to add a line in the macro that will run the EXE and then continue to run itself. It would save a lot of time and effort.
Thanks in advance
andrew299

 

[RobBroekhuis]

The question is what do you mean by "and then"? You want the exe to run and finish, with the macro waiting until the exe has completed? Or do you want them to run simultaneously?
Rob

 

[andrew299]

What I want is for the exe to run and finish, with the macro waiting until the exe has finished.
Thanks

 

[RobBroekhuis]

Unfortunately, that's the more difficult scenario (the default for processes launched with the "shell" command is the opposite). I don't know the best way to accomplish what you're going for. I've seen code before that checks whether the process' task id (returned by the shell function) is still running, but I've not done it myself. I think someone here will be able to help you in more detail.
Rob