WorksheetFunction.RTD method (Excel)

This method connects to a source to receive real-time data (RTD).

Syntax

expression.RTD (progID, server, topic1, topic2, topic3, topic4, topic5, topic6, topic7, topic8, topic9, topic10, topic11, topic12, topic13, topic14, topic15, topic16, topic17, topic18, topic19, topic20, topic21, topic22, topic23, topic24, topic25, topic26, topic27, topic28)

expression An expression that returns a WorksheetFunction object.

Parameters

Name	Required/Optional	Data type	Description
progID	Required	Variant	A string representing the real-time server programmatic identifier.
server	Required	Variant	A server name, Null string, or vbNullString constant.
topic1	Required	Variant	A String representing a topic.
topic2 – topic28	Optional	Variant	A String representing a topic.

Return value

Variant

Remarks

The server argument is required in Visual Basic for Applications (VBA), even though it can be omitted on a worksheet.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.