Home |
Search |
Today's Posts |
#1
|
|||
|
|||
capture DDE update value in VBA macro
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 |
#2
|
|||
|
|||
what happens if you send the request twice?
-- Regards, Tom Ogilvy "chs245" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Macro to Update Chart | Charts and Charting in Excel | |||
automatic macro update | Excel Worksheet Functions | |||
Date macro | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) |