Class RTD (Excel VBA)

The class RTD represents a real-time data object.

Item

To use a RTD class variable it first needs to be instantiated, for example

Dim rtd as RTD
Set rtd = Application.RTD

RTD class variables can be set using the Application.RTD procedure.

RefreshData

Requests an update of real-time data from the real-time data server.

Avoid using the RefreshData method in user-defined functions because this method will fail if it is called during recalculation.

Application.RTD.RefreshData

RestartServers

Reconnects to a real-time data server (RTD).

Application.RTD.RestartServers

ThrottleInterval

Returns or sets a Long indicating the time interval between updates.

The default value is 2000 milliseconds. If this value is changed, the new value will persist when Microsoft Excel is restarted.

Application.RTD.ThrottleInterval =