Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function call syncronized.
Hi all!
I have to syncronize 2 functions: that is, I have to wait a finish of one function before launching the other. the functions are api of another application, so I can't check the return code. Any idea? milly |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function call syncronized.
milly wrote: Hi all! I have to syncronize 2 functions: that is, I have to wait a finish of one function before launching the other. the functions are api of another application, so I can't check the return code. Any idea? milly If the first function creates a change of state that you can monitor (e.g. - writes to a file or changes the content of cell A1) then maybe you could create a wrapper for the second function: A simple loop that contains a DoEvents (to allow the first function to complete) and checks if the change of state has happened. When it has, control leaves the loop and passes to the second function. Hopefully someone else has a better solution, but the above solution could work in a pinch. -John Coleman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a do not call function? | Excel Discussion (Misc queries) | |||
With 2 pivotcharts, can I keep their page selections syncronized? | Excel Discussion (Misc queries) | |||
call a function from VBA | Excel Programming | |||
Function Call | Excel Programming | |||
call function | Excel Programming |