Application.DDEInitiate (Word)

Opens a dynamic data exchange (DDE) channel to another application, and returns the channel number.

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.

DDEInitiate (App, Topic)

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

Arguments

The following arguments are required:

App (String) - The name of the application.

Topic (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.