DDE Link problem..

dlbatsford

New Member
Joined
Sep 29, 2006
Messages
1
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
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
L

Legacy 98055

Guest
See the SetLinkOnData method...

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

nada

Board Regular
Joined
Jul 4, 2006
Messages
193
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.
 

Forum statistics

Threads
1,137,335
Messages
5,680,887
Members
419,937
Latest member
Talic

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top