WorksheetFunction.RTD Method (Excel)

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

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	Optional	Variant	A String representing a topic.
topic3	Optional	Variant	A String representing a topic.
topic4	Optional	Variant	A String representing a topic.
topic5	Optional	Variant	A String representing a topic.
topic6	Optional	Variant	A String representing a topic.
topic7	Optional	Variant	A String representing a topic.
topic8	Optional	Variant	A String representing a topic.
topic9	Optional	Variant	A String representing a topic.
topic10	Optional	Variant	A String representing a topic.
topic11	Optional	Variant	A String representing a topic.
topic12	Optional	Variant	A String representing a topic.
topic13	Optional	Variant	A String representing a topic.
topic14	Optional	Variant	A String representing a topic.
topic15	Optional	Variant	A String representing a topic.
topic16	Optional	Variant	A String representing a topic.
topic17	Optional	Variant	A String representing a topic.
topic18	Optional	Variant	A String representing a topic.
topic19	Optional	Variant	A String representing a topic.
topic20	Optional	Variant	A String representing a topic.
topic21	Optional	Variant	A String representing a topic.
topic22	Optional	Variant	A String representing a topic.
topic23	Optional	Variant	A String representing a topic.
topic24	Optional	Variant	A String representing a topic.
topic25	Optional	Variant	A String representing a topic.
topic26	Optional	Variant	A String representing a topic.
topic27	Optional	Variant	A String representing a topic.
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 within a worksheet.

See Also

Concepts

WorksheetFunction Object Members

WorksheetFunction Object