DDEInitiate Method

Microsoft Excel Visual Basic

Opens a DDE channel to an application.

expression.DDEInitiate(App, Topic)

expression    Optional. An expression that returns an Application object.

App    Required String. The application name.

Topic    Required String. Describes something in the application to which you're opening a channel— usually a document of that application.

Remarks

If 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 opens a channel to Word, opens the Word document Formletr.doc, and then sends the FilePrint command to WordBasic.

channelNumber = Application.DDEInitiate( _
    app:="WinWord", _
    topic:="C:\WINWORD\FORMLETR.DOC")
Application.DDEExecute channelNumber, "[FILEPRINT]"
Application.DDETerminate channelNumber