This method is called by Microsoft Excel to get new data. Returns a Variant.
expression.RefreshData(TopicCount)
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 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
Avoid using the RefreshData method in user-defined functions because this method will fail if it is called during recalculation.