Skip to content

Latest commit

 

History

History
46 lines (30 loc) · 1.11 KB

Excel.Application.DDETerminate.md

File metadata and controls

46 lines (30 loc) · 1.11 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Application.DDETerminate method (Excel)
vbaxl10.chm183094
vbaxl10.chm183094
Excel.Application.DDETerminate
f05adf6d-5714-12c4-39ce-af4bc31f4d32
04/04/2019
medium

Application.DDETerminate method (Excel)

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.

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

[!includeSupport and feedback]