Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Threaded programming in VBA
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" wrote in message oups.com... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi threaded calculation (multi CPU) - impact on calculation spe | Excel Discussion (Misc queries) | |||
CD Programming | Excel Discussion (Misc queries) | |||
DDE Programming | Excel Programming | |||
Help with programming | Excel Programming | |||
Do I need programming for this? | Excel Programming |