how to stop the parent sub when a child (i.e. called) sub stops in the middle

[lindalibinbin]

I have a procedure that looks like this:

sub parent()

call child1

call child2

end sub


My question is, since child1 grabs the correct files, and child2 processes the new files, when child1 stops (i.e. feed file not ready to be grabbed), the whole thing should stop right there. But when I ran it, it will still continue onto child2, which in turn wastes time processing OLD data. So how do I tell the parent sub to stop if child1 cannot run all the way to its end?

Thanks!!

 

[jparfitt87]

sounds like you need to throw in an error handler to basically say, if file reaches X then Exit Sub.
This could be placed in each of your subs

without seeing the code or more detail thats the best i can think of.

Regards

 

[RoryA]

Three ways I can think of:
1. Change your subs to Functions that return True if they succeed, or False if not. The calling code can then simply check the result:

sub parent()

If child1 = False then Exit sub

Call child2

end sub

2. Use an error handler in your calling sub and raise an unhandled error in the called sub - this will come back up the stack to the parent.
3. Use End. This should be a last resort!