Class RTD (Excel VBA)

The class RTD represents a real-time data object.


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.


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


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.