IRtdServer Members (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Represents an interface for a real-time data server.

Name

Description

ConnectData

Adds new topics from a real-time data server. The ConnectData method is called when a file is opened that contains real-time data functions or when a user types in a new formula which contains the RTD function.

DisconnectData

Notifies a real-time data (RTD) server application that a topic is no longer in use.

Heartbeat

Determines if the real-time data server is still active. Returns a Long value. Zero or a negative number indicates failure; a positive number indicates that the server is active.

RefreshData

This method is called by Microsoft Excel to get new data. Returns a Variant.

ServerStart

The ServerStart method is called immediately after a real-time data server is instantiated. Returns a Long; negative value or zero indicates failure to start the server; positive value indicates success.

ServerTerminate

Terminates the connection to the real-time data server.

Show: