I have a dde connection to a server established via the following
code:
channelNumber = Application.DDEInitiate( _
app:="BDDE", _
topic:="HIST")
returnList = Application.DDERequest(channelNumber, item$)
For i = LBound(returnList) To UBound(returnList)
Worksheets("Sheet1").Cells(i, 1).Formula = returnList(i)
Next i
Application.DDETerminate channelNumber
The DDE server first sends the value "<WFR>" to tell the user that it
is working on the request, and once the data is available, it sends
it
a couple of seconds later. The problem is that the macro only
captures
the value <WFR>, and not the data that follows a couple of seconds
later.
Is there a way to retrieve this late-incoming data via the macro ?