Class RTD (Excel VBA)
The class RTD represents a real-time data object.
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.
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.