DDERequest Method

Microsoft Excel Visual Basic

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