Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
external data access problem
I have an excel sheet which has dozens of cells
being updated by a program called RSLinx. This program poles a controller on a network for values stored in its memory, these values are then displayed visually in the Excel sheet. My problem is this: If I attempt to run a Visual Basic Routine or a macro from Excel the sheet will not update as long as the routine/macro runs. I am updating the cells using syntax like this: Worksheet("Sheet1").[A1] = [RSLINX|SVRNAME! 'I:000/00,L1'] The cause appears to be that focus is placed entirely on Excel while the routine runs so RSLinx does not get poled until Excel returns to the background at the end of the routine's execution. The question I need answered is: Can Excel be made to run it's routines in the background so that RSLinx can get CPU time to update it's data? If so how? Gary |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
external data access problem
You can try to intersperse
DoEvents in your code - especially if you are looping, put it in the loop. Regards, Tom Ogilvy Gary Desroches wrote in message ... I have an excel sheet which has dozens of cells being updated by a program called RSLinx. This program poles a controller on a network for values stored in its memory, these values are then displayed visually in the Excel sheet. My problem is this: If I attempt to run a Visual Basic Routine or a macro from Excel the sheet will not update as long as the routine/macro runs. I am updating the cells using syntax like this: Worksheet("Sheet1").[A1] = [RSLINX|SVRNAME! 'I:000/00,L1'] The cause appears to be that focus is placed entirely on Excel while the routine runs so RSLinx does not get poled until Excel returns to the background at the end of the routine's execution. The question I need answered is: Can Excel be made to run it's routines in the background so that RSLinx can get CPU time to update it's data? If so how? Gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2010 (64 bit) External Data connection with Access | Excel Discussion (Misc queries) | |||
Getting external data from Access 2007 using msquery | Excel Discussion (Misc queries) | |||
Get External Data from Access Parameter Query | Excel Discussion (Misc queries) | |||
Error when importing external data from Access | Excel Discussion (Misc queries) | |||
MONTHNAME when getting external data from Access | Excel Worksheet Functions |