Try looking here, it may help:
http://www.business-spreadsheets.com/forum.asp?t=40
"Graeme" wrote:
How do I import data into Excel from Bloomberg using Excel 2007 (Microsoft
Vista)?
I need to import historical prices of 14 tickers into the same workbook.