Simulating a synchronous process

[Russ]

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

 

[Ivan F Moala]

Hi Russ
This may be of use (Also includes a few other links)
http://www.xcelfiles.com/VBA_01.html#anchor_16

 

[Toby Erkson]

Ah, another excellent Excel web site for my favorites...good info!

Just one thing, change every spelling of "weather" to "whether" on your web site unless you are talking about the sun/wind/rain ;-) It's okay, if it weren't
for spell-checking features people would have a hard time believing I graduated high school
Toby Erkson
Oregon, USA

 

[Russ]

Thanks Toby and Ivan! This is exacly what I'm looking for.

BTW, sorry to reply so late after your response <

Thanks again,

- Russ

-----Original Message-----
Ah, another excellent Excel web site for my favorites...good info!

Just one thing, change every spelling of "weather"

to "whether" on your web site unless you are talking about
the sun/wind/rain ;-) It's okay, if it weren't

for spell-checking features people would have a hard time

believing I graduated high school

Toby Erkson
Oregon, USA