B
blinkots
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
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