RTD |
RTD(progID, server, topic1 [,topic2]) |
Returns the real time data from a program that supports COM. |
progID | The name of the registered COM add-in. |
server | The name of the server running the add-in. |
topic1 | The first argument to pass to the server. |
topic2 | (Optional) The second argument to pass to the server. |
REMARKS |
* For an illustrated example refer to the RTD Server page. * The RTD COM automation add-in must be installed and registered on the computer. * No RTD servers are shipped with Microsoft Office, so you must manually install a real-time data server if you want to use this function. * The "progID" must be enclosed in speech marks. * The "server" can be left blank for testing but if the data is coming from a different machine, this machine name must be provided. * If the real-time data server is being run locally then leave the "server" argument blank. * This function will only continuously update when the calculation mode is set to automatic. * When using RTD within Visual Basic for Applications (VBA), double quotation marks or the VBA NullString property are required for the server, even if the server is running locally. * You can have a maximum of 28 topics. * This function was added in Excel 2003. * For the Microsoft documentation refer to support.microsoft.com |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top