DDERequest Method [Excel 2003 VBA Language Reference]

  • Article

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

Applies to | Application Object