Simulating a synchronous process

R

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
 
T

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 :cool:
Toby Erkson
Oregon, USA
 
R

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"
Click to expand...
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
Click to expand...
believing I graduated high school :cool:
Toby Erkson
Oregon, USA
Click to expand...
 
Top