Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
overlapped functions in vba for excel
Hello All
I have written a vba app to get data from a device and display it on a graph in excel. The data is fetched via the serial port using the Win32 communications api. These functions used are overlapped, hence the other threads & applications run as normal during a relatively slow communications. Essentially the overall algorithm is: cell =1 while cell < 100 if data available or timeout place data or error in cell cell++ This locks excel in the while loop, busy and cannot respond to user commands. How do I put something in this loop to say ' check the rest of excel needs'? Thanks in anticipation. Billy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
overlapped functions in vba for excel
Add
DoEvents in each iteration of the loop. -- HTH RP (remove nothere from the email address if mailing direct) "blinkots" wrote in message ... Hello All I have written a vba app to get data from a device and display it on a graph in excel. The data is fetched via the serial port using the Win32 communications api. These functions used are overlapped, hence the other threads & applications run as normal during a relatively slow communications. Essentially the overall algorithm is: cell =1 while cell < 100 if data available or timeout place data or error in cell cell++ This locks excel in the while loop, busy and cannot respond to user commands. How do I put something in this loop to say ' check the rest of excel needs'? Thanks in anticipation. Billy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
overlapped functions in vba for excel
Bob Phillips wrote:
Add DoEvents in each iteration of the loop. Thanks .. this did help. Billy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
old excel file overlapped with new excel file | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Public Functions As Worksheet Available Functions | Excel Programming | |||
excel functions and User defined functions | Excel Programming |