WorksheetFunction.RTD (Excel)
This method connects to a source to receive real-time data (RTD).
The server argument is required in Visual Basic for Applications (VBA), even though it can be omitted on a worksheet.
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)
Dim strtopic1 As String: strtopic1 =
Dim varRTD As Variant
varRTD = WorksheetFunction.RTD(progID:=, server:=, topic1:=strtopic1)
Arguments
The following arguments are required:
progID - A string representing the real-time server programmatic identifier
server - A server name, Null string, or vbNullString constant
topic1 (String) - A String representing a topic.
Optional arguments
The following arguments are optional
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 (String) - A String representing a topic.