Programming Function
Tried it, didn't work the way I was hoping. It does return AUD Curncy in a
cell, but I think I didn't provide enough information about the problem. So
in my code, I want to execute the Bloomberg function which works fine if I
manually put in Function = [BDP("AUD Curncy","LAST_PRICE")] but does not work
when I substitute the variable below, that's when I have problems. Any ideas?
"Bob Phillips" wrote:
One more each time
"""" & FULLBBCODE & """"
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Matt" wrote in message
...
I'm attempting to program a new function that includes other functions
provided by Bloomberg professional service. The end result needs to look
like this:
BDP("AUD Curncy","LAST_PRICE")
The AUD Curncy is Bloomberg's security code, which I will be getting from
two separate cells. I am able to put the two cells together as follows:
BBCODE = AUD
BBKEY = Curncy
FULLBBCODE = BBCODE & BBKEY
My problem is that I need to get quotation marks around the FULLBBCODE in
the VBA code. When I've tried """ & FULLBBCODE &""" it just returns that
exact text, not what FULLBBCODE represents. Hope I've explained this
enough,
any help would be greatly appreciated.
|