Global.DDEInitiate method (Word)
Opens a dynamic data exchange (DDE) channel to another application, and returns the channel number.
Syntax
expression. DDEInitiate
( _App_
, _Topic_
)
expression A variable that represents a 'Global' object. Optional.
Parameters
Name | Required/Optional | Data type | Description |
---|---|---|---|
App | Required | String | The name of the application. |
Topic | Required | String | The name of a DDE topic—for example, the name of an open document—recognized by the application to which you are opening a channel. |
Remarks
If it is successful, the DDEInitiate method returns the number of the open channel. All subsequent DDE functions use this number to specify the channel.
Example
This example initiates a DDE conversation with the System topic and opens the Microsoft Office Excel workbook Sales.xls. The example terminates the DDE channel, initiates a channel to Sales.xls, and then inserts text into cell R1C1.
Dim lngChannel As Long
lngChannel = DDEInitiate(App:="Excel", Topic:="System")
DDEExecute Channel:=lngChannel, Command:="[OPEN(" & Chr(34) _
& "C:\Sales.xls" & Chr(34) & ")]
DDETerminate Channel:=lngChannel
lngChannel = DDEInitiate(App:="Excel", Topic:="Sales.xls")
DDEPoke Channel:=lngChannel, Item:="R1C1", Data:="1996 Sales"
DDETerminate Channel:=lngChannel
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기