Application.DDETerminate Method

  • Article
Excel Developer Reference

Closes a channel to another application.

Syntax

expression.DDETerminate(Channel)

expression   A variable that represents an Application 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.

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

See Also