Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

DDEPoke Method [Access 2003 VBA Language Reference]

Office 2003

You can use the DDEPoke statement to supply text data from a client application to a server application over an open dynamic data exchange (DDE) channel.

expression.DDEPoke(ChanNum, Item, Data)

expression Required. An expression that returns one of the objects in the Applies To list.

ChanNum  Required Variant. A channel number, an integer returned by the DDEInitiate function.

Item  Required String. A string expression that's the name of a data item recognized by the application specified by the DDEInitiate function. Check the application's documentation for a list of possible items.

Data  Required String. A string containing the data to be supplied to the other application.

Remarks

For example, if you have an open DDE channel between Microsoft Access and Microsoft Excel, you can use the DDEPoke statement to transfer text from a Microsoft Access database to a Microsoft Excel spreadsheet. In this example, Microsoft Access acts as the client application, and Microsoft Excel acts as the server application.

The value of the item argument depends on the application and topic specified when the channel indicated by the channum argument is opened. For example, the item argument may be a range of cells in a Microsoft Excel spreadsheet.

The string contained in the data argument must be an alphanumeric text string. No other formats are supported. For example, the data argument could be a number to fill a cell in a specified range in an Excel worksheet.

If the channum argument isn't an integer corresponding to an open channel or if the other application doesn't recognize or accept the specified data, a run-time error occurs.



Applies to | Application Object


Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.