WorksheetFunction.RTD Method
| Excel Developer Reference |
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