RefreshData Method

Microsoft Excel Visual Basic

Show All

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.