Application.DDEPoke method (Excel)

Sends data to an application.

Syntax

expression.DDEPoke (Channel, Item, Data)

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.
Item	Required	Variant	The item to which the data is to be sent.
Data	Required	Variant	The data to be sent to the application.

Remarks

An error occurs if the method call doesn't succeed.

Example

This example opens a channel to Word, opens the Word document Sales.doc, and then inserts the contents of cell A1 (on Sheet1) at the beginning of the document.

channelNumber = Application.DDEInitiate( _ 
 app:="WinWord", _ 
 topic:="C:\WINWORD\SALES.DOC") 
Set rangeToPoke = Worksheets("Sheet1").Range("A1") 
Application.DDEPoke channelNumber, "\StartOfDoc", rangeToPoke 
Application.DDETerminate channelNumber

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.