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