There are a couple of ways to do this. This
link describes one of them. I would suggest you run the
shellandwait function in a loop until you receive a
success return code.
Another possibility is to create a Windows Shell object in your code and use the
run method to execute your batch file. Unlike the VBA shell command, the
run method has a wait on return parameter you can set to
true.
Good luck.