Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

capture DDE update value in VBA macro

  Asked By: Bryant    Date: Dec 29    Category: MS Office    Views: 1148
  

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 ?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on capture DDE update value in VBA macro Or get search suggestion and latest updates.




Tagged: