Macro that waits for sub to finish

Z

zac

hello,
I've setup a macro to run using VBA and/or VB using the
A.DoCmd.RunMacro "MacroName" proceeded by an A.DoCmd.Quit.
The Macro runs a series of different Functions using
Runcode - Function Name - Function(), one of which takes
an hour and a half to finish. How do I setup VB(A) to
wait for each Runcode FunctionName() to finish before
ending the VB(A) session that kicks off the Macro that
runs the individual functions?

desparate,
Zachary
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
For Next Loop Using Access Basic Function to Maintain a Counter 0
Name of currently running macro... 1
Excel 2007: Creating a macro that will run Solver. 0
Excel 2007: Help creating a macro that will run Solver? 3
Excel 2007: Help creating a macro that will run Solver? 0
lotus notes waits for me to send email? 1
AutoExec Macro not passing OpenArgs 4

Top