When I use Bloomberg API calls (i.e. the "BLP" function) to
extract information from Bloomberg into an MS Excel spreadsheet,
it works fine as long as I'm at a Bloomberg-enabled PC.
But when I open the sheet on another PC, the first thing Excel
does is issue the "Do you want to update stuff..." prompt.
Viz:
http://tinyurl.com/36savd
I'd think that replying "Don't update" would preserve the values,
but it's no-go:
http://tinyurl.com/3yquhe
My current kludge is to do a Select All and then paste everything
into an MS Word document.
Push comes to shove, I'm guessing I could write a VBA macro to
boogie through all the cells and copy .Data or .Value... or
whatever property the good stuff lives in... to another sheet in
the same workbook while it's open on a Bloomberg-enabled PC.
Still... seems like a lot of work if I'm just doing something
dumb in the first place.
Anybody know how to preserve the values on another PC without a
lot of kludging?
--
PeteCresswell
Similar Threads
