Hello,

In my VBA macro, I'm running an external application
(Clear Access, in this case) to get the data I need.
Unfortunately, a Clear Access query runs asynchronously,
so that the macro continues to run.

However, I want Excel to wait for the results of the query
to come back before continuing on. (For example, what if
there are no records returned?)

How do I do this? Is there a way that Excel can
be "fooled" into waiting for another application to finish
before proceeding?

Any help would be greatly appreciated. Thanks,

-- Russ