Retrieve real-time data from COM Automation-enabled programs
Syntax
RTD(ProgID, server, topic1, [topic2], ...)
RTD function syntax has the following parameters:
ProgID: required. The name of the registered COM Automation add-on ProgID that is installed on the local computer. Enclose the name in quotation marks.
server: required. The name of the server on which the add-in should run. If there is no server, to run the program locally, leave this parameter empty.
Topic1, topic2, ... : Topic1 is required, subsequent topics are optional. 1 to 253 parameters, which together represent a unique
Real-time data.
Description
The RTD COM Automation add-in must be created and registered on the local computer.
If the real-time data server is not installed, an error message will appear in the cell when trying to use the RTD function.
Unlike other functions, RTD formulas will change while Microsoft Excel is in automatic calculation mode if the server continues to update results.
The role of the RTD function is to reference real-time data from COM, thereby greatly expanding the purpose of information exchange between Excel and external programs.
This function is often used to create automatically updated stock information tables. Things to note when using this function are:
The RTD COM Automation add-in must be created and registered on the local computer; if the real-time data server is not installed, an error value will be returned.
After we successfully create an automation add-in, we can use this function to reference data. Next, we will show you the specific steps of using this function in this table:
■Select cell U14, click Insert Function, search and find the RTD function in the Search box, and click OK;
■Here we have to enter three values
Prog ID: a ProgID name for registering a COM automation add-in. The name should be placed in double quotes;
Server
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/RTD-han-shu-huo-qu-shi-shi-shu-ju-de-zhi-neng-fang-fa.html
评论列表(196条)
测试