Retrieving Data from Bloomberg Through Excel

[chris1 via AccessMonster.com]

Can Bloomberg data be directly imported into Access? If no, I have code that
tries to retrieve data from Excel into Access but the Bloomberg API - BlpMain.
xla is not loaded when I use the following code:

Private Sub Command0_Click()
Dim objXL As Excel.Application
Dim objWS As Excel.Worksheet

Set objXL = New Excel.Application
objXL.Workbooks.Add
objXL.Visible = True
Set objWS = objXL.Activesheet

objXL.AddIns.Add(Filename:="C:\Program Files\Blp\BlpMain.xla").Installed =
True
objWS.cells(1,1).Formula = "=blph(""CUSIP mtge",""MTG_HIST_FACT"")"
End sub

This doesn't to work when Access opens Excel. However when I open Excel by
itself the Bloomberg API loads up.

Please help me with any suggestions or ideas.

 

[Guest]

Does Bloomberg provide any other documentation? You used to be
able to get the data using DDE,
channelNumber = Application.DDEInitiate(app:="BLP", topic:="S")
and there may be a Bloomberg OLE object
blbg = createobject('Bloomberg.Data.1')

AFAIK, the xla is just a wrapper for Bloomberg DDE

(david)