Threaded programming in VBA

Hi

Does VBA (Excel) offer any tools for threaded programming?

If one uses the wait for child API call, it is possible to pause a VBA
macro, while some other program runs, producing some data, for the
macro.

But if the child program takes a long time to finish its work, Excel is
blocked, waiting for the child. Just imagine the irritation of the
users.

Is there some way to use synchronization, in VBA, so part of the code
waits for the child while another keeps running with limited access to
variables, ranges and so on?

I hope this is understandable (I'm not completely sure I understand
myself). I guess what I'm trying to do is to gain control not only over
what Excel does, but also when it does it. And preferebly more than one
thing at the time.

VBA has no support whatsoever for multiple threads. All code must
be run synchronously.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Martin" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> Does VBA (Excel) offer any tools for threaded programming?
>
> If one uses the wait for child API call, it is possible to
> pause a VBA
> macro, while some other program runs, producing some data, for
> the
> macro.
>
> But if the child program takes a long time to finish its work,
> Excel is
> blocked, waiting for the child. Just imagine the irritation of
> the
> users.
>
> Is there some way to use synchronization, in VBA, so part of
> the code
> waits for the child while another keeps running with limited
> access to
> variables, ranges and so on?
>
> I hope this is understandable (I'm not completely sure I
> understand
> myself). I guess what I'm trying to do is to gain control not
> only over
> what Excel does, but also when it does it. And preferebly more
> than one
> thing at the time.
>