Application.DDEInitiate method (Excel)

Opens a DDE channel to an application.

Syntax

expression.DDEInitiate (App, Topic)

expression A variable that represents an Application object.

Parameters

Name	Required/Optional	Data type	Description
App	Required	String	The application name.
Topic	Required	String	Describes something in the application to which you are opening a channel, usually a document of that application.

Return value

Long

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

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.