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