LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Pulling data OUT of Excel in real-time.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Real Time Collection and Display of Data by Excel Steve Landry Excel Programming 2 April 26th 06 02:52 PM
Examples of using Bloomberg API / real time data with Excel VBA? John.Greenan Excel Programming 0 April 21st 06 04:00 PM
Excel 2003's autosum does not update data in real time KokWoei Excel Worksheet Functions 2 April 4th 06 05:12 AM
Excel VBA macros and real time data calculations [email protected] Excel Programming 5 July 7th 05 04:43 PM
excel focus problems with custom RTD server (real time data) S Guy Excel Programming 3 February 1st 05 06:24 PM


All times are GMT +1. The time now is 09:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"