Skip to content

Latest commit

 

History

History
57 lines (28 loc) · 1.23 KB

4b14e2ee-d7b0-a028-42a7-0809fa381f7e.md

File metadata and controls

57 lines (28 loc) · 1.23 KB

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're 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

See also

Concepts

Application Object

Other resources

Application Object Members