DDERequest Method
Requests information from the specified application. This method always returns an array; for more information, see the example.
expression.DDERequest(Channel, Item)
expression Optional. An expression that returns an Application object.
Channel Required Long. The channel number returned by the DDEInitiate method.
Item Required String. The item to be requested.
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.
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