DDE Link problem..

[dlbatsford]

Hi,

in my VBA im using code to pull in a data field from Bloomberg. this is done viia bloombergs DDE server which runs when i open Excel.

the code is

Range("w4").Formula = "=BLP|M!'" & ticker & " EQUITY,[VOLUME_AVG_10D]'"

This can take a good 3 seconds to pull in the data, the problem i have is that it doesnt start to pull in the data until my macro/sub has finished but i need to use the information it pulls in before the macro finishes. (hope that makes sense)

Ive tried delaying/looping etc but it doesnt free up to update from external dde links.

im not hugely techy so if ive left anything out just tell me what you need. Thanks in advance to all who reply.

Darren

 

[Legacy 98055]

See the SetLinkOnData method...

Or you could use a Do...Loop in concurrence with the DoEvents function.

 

[nada]

bb

H dlbatsford! I also write stuff to connect bb with xl. What you want to do is to have something that checks the outcome from the Blp question in a loop and not let it pass unless you have gotten a valid answer.... Why are you writing the formula onto the spreadsheet instead of asking a direct question to BB?

if istring(Range("w4").Value) then
end if

that might work...havent tried it. also you that you can check out BBXL<GO> and WAPI<GO>. they have some stuff there.