D Douglas J. Steele Mar 5, 2005 #2 Do you mean you want your VBA to wait until the Shell function has completed its execution? Take a look at http://www.mvps.org/access/api/api0004.htm at "The Access Web"
Do you mean you want your VBA to wait until the Shell function has completed its execution? Take a look at http://www.mvps.org/access/api/api0004.htm at "The Access Web"
T Tom Mar 6, 2005 #3 HAve a look at cthe code at: ourworld.compuserve.com/homepages/attac-cg/ACodeTip.htm#SHELL7 Tom