capture DDE update value in VBA macro

[chs245]

Hi
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 ?

Many thanks in advance,

Oliver

 

[Tom Ogilvy]

what happens if you send the request twice?

 

[O r]

If i send the request twice, i will still only get <WFR> as my initial
answer. it would be nice to kind of "listen" to a dde connection from
within an excel macro.

 

[Tom Ogilvy]

Apparently DDE is asynchronous, but VB/VBA is not designed to work that way.
You might go to this page
http://www.angelfire.com/biz/rhaminisys/ddeinfo.html

Read down to the DDEML section. They have a link embedded there to a page
that talks about VB and DDE and that link does talk about asynchronous
processing in VB - their solution is to use their controls.

http://www.angelfire.com/biz/rhaminisys/ddclient.html

for the client. Looks like it is free.

 

[Tom Ogilvy]

One more link about VBA and the client control specifically:

http://www.angelfire.com/biz/rhaminisys/ddclvba.html

 

[chs245]

Thanks Tom,

seems to me that most of the developer community has given-up on DDE
years ago. The software found on your link seems to solve the problem
though.

Best regards,

OLiver