Application.DDETerminate Method (Excel)

Closes a channel to another application.

Syntax

expression. DDETerminate( _Channel_ )

expression A variable that represents an [Application](./Excel.Application(Graph property).md) object.

Parameters

Name Required/Optional Data Type Description
Channel Required Long The channel number returned by the DDEInitiate method.

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

Application Object