Hi JEM,
SUMMARY
This step-by-step article discusses the new functionality that the
RealTimeData (RTD) function provides. Microsoft Excel 2002 provides a new
worksheet function, RealTimeData (RTD), which allows you to call a
Component Object Model (COM) Automation server for the purpose of
retrieving data in real time.
When you need to create a workbook that includes data that is updated in
real time -- for example, financial or scientific data -- you can now use
the RTD worksheet function. In earlier versions of Excel, Dynamic Data
Exchange (DDE) is used for that purpose. However, the RTD function, which
is based on COM technology, provides advantages in terms of robustness,
reliability, and convenience. RTD depends on the availability of an RTD
server to make the real-time data available to Excel. For more information
about how to create an RTD server, see the "References" section of this
article.
The RTD function retrieves data from an RTD server for use in the workbook.
The function result is updated whenever new data becomes available from the
server and the workbook is able to accept it. The server waits until Excel
is idle before updating, which relieves the developer of having to
determine whether Excel is available to accept updates. The RTD function
differs from other functions in this regard, because other functions are
updated only when the worksheet is recalculated.
Although the RTD function provides a link to data on a server, it is not
the same type of link as references to cells in other worksheets or
workbooks. For example, if you use the RTD function in a workbook, you do
not receive the Links startup message when you open the workbook, nor can
you manage the status of an RTD function through the Edit Links dialog box.
HOW TO: Set Up and Use the RTD Function in Excel 2002 Microsoft
Knowledge Base Article - 289150
http://support.microsoft.com/default.aspx?scid=kb;en-us;289150
HOWTO: Automate Microsoft Excel from Visual Basic Microsoft Knowledge
Base Article - 219151
http://support.microsoft.com/default.aspx?scid=kb;en-us;219151
Please let me know has this helped You...
Thank You...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.
