Shell command to check if program stops running!

[ITboy]

I'm doing a VBA program whereby it reads text files(That is not the problem). Those text files are created by a perl program. At one point, I would need to click a button in my Userform to activate the perl program to execute. Also, to prevent the compiler from reading the next line in my code(y? coz the text files wouldn't be created yet coz they are BIG n SEVERAL of them need to be created), how am I to pause my program to check whether the files are created(NOT IF THE FILES R THERE COZ THE FILES MAY EXISTS BUT NOT ALL THE DATA ARE CREATED.HOPE U UNDERSATND THIS) OR whether the perl program has stopped running.I've got a "plain" Shell func but not with this conditions to loop n check. Any body who knows this pls help .Attached is how my Shell func is like(ive put it in a notepad).Feel free to make changes in it and send me if u know how to work it out.Thanks a 1000 times.