RefreshData Method
RefreshData method as it applies to the IRtdServer object.
This method is called by Microsoft Excel to get new data. This method call only takes place after being notified by the real-time data server that there is new data.
expression.RefreshData(ByRef TopicCount As Long)
expression Required. An expression that returns an IRtdServer object.
TopicCount Required Long. The RTD server must change the value of the TopicCount to the number of elements in the array returned.
Remarks
The data returned to Microsoft Excel is a Variant containing a two-dimensional array. The first dimension represents the list of topic IDs. The second dimension represents the values associated with the topic IDs.
RefreshData method as it applies to the RTD object.
Requests an update of real-time data from the real-time data server.
expression.RefreshData
expression Required. An expression that returns an RTD object.
Remarks
Using the RefreshData method during recalculation will fail, so it should not be used within user-defined functions.