WorksheetFunction.RTD Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

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

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

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

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

Show: