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.