Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel screen capture to capture cells and row and column headings | Excel Discussion (Misc queries) | |||
How to use Macro to capture snapshots of RTD prices? | Excel Discussion (Misc queries) | |||
Macro to capture worksheet names | Excel Worksheet Functions | |||
capture DDE update value in VBA macro | Excel Discussion (Misc queries) | |||
Capture Screen to *.gif file via VBA Macro | Excel Programming |