DDEInitiate Method

Microsoft Excel Visual Basic

DDEInitiate Method

       

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