Export (0) Print
Expand All

Application.DDETerminate Method (Excel)

Published: July 16, 2012

Closes a channel to another application.

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft