Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am looking for a way to pull data OUT of Excel XP (Excel 2002) in real-time.
Data are scattered in different worksheets belonging to one workbook and come from a real time feed on which is applied some calculations (excel formulas). I'd say there are about two hundred cells to monitor. What I need to do is to pull out those data as they change (in real-time). The excel GUI must remain responsive as users may need to input data themselves. At first I was considering using the 2.0 .NET framework and Excel PIA to subscribe to the Worksheet_Change event (or any other...), but I fear (from my first test) the Excel UI might become non-responsive. I was also considering looking into VSTO (Visual Studio Tools for Office) but I'm not familiar at all with it so I'm looking for advice. From what I understood, VSTO won't work with Office XP but upgrading to higher version of Office is an option. Basically I am an experienced .NET developer with no experience in Office development, so any piece of advice is welcome. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Real Time Collection and Display of Data by Excel | Excel Programming | |||
Examples of using Bloomberg API / real time data with Excel VBA? | Excel Programming | |||
Excel 2003's autosum does not update data in real time | Excel Worksheet Functions | |||
Excel VBA macros and real time data calculations | Excel Programming | |||
excel focus problems with custom RTD server (real time data) | Excel Programming |