Syntax

expression.DDERequest(Channel, Item)

expression A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
Channel Required Long The channel number returned by the method.
Item Required String The item to be requested.

Return Value
Variant

Example

This example opens a channel to the System topic in Word and then uses the Topics item to return a list of all open documents. The list is returned in column A on Sheet1.

Visual Basic for Applications 
channelNumber = Application.DDEInitiate( _ app:="WinWord", _ topic:="System") returnList = Application.DDERequest(channelNumber, "Topics") For i = LBound(returnList) To UBound(returnList) Worksheets("Sheet1").Cells(i, 1).Formula = returnList(i) Next i Application.DDETerminate channelNumber
Bring in external data via dde channel? dde request DDE Request Method DDERequest dderequest method Import data from another application via dynamic data exchange? Request information from another application?

See also: