Programming Function
in [Programming]
|
Prev: rename message
Next: weight watchers quick tracker
From: Matt on 27 Aug 2007 09:56 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.
From: Bob Phillips on 27 Aug 2007 10:16 One more each time """" & FULLBBCODE & """" -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Matt" <Matt(a)discussions.microsoft.com> wrote in message news:5A807E22-29AA-4474-A700-C6BE1510BF0D(a)microsoft.com... > 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.
From: Matt on 27 Aug 2007 10:30 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" <Matt(a)discussions.microsoft.com> wrote in message > news:5A807E22-29AA-4474-A700-C6BE1510BF0D(a)microsoft.com... > > 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. > > >
From: Zone on 27 Aug 2007 12:09 How about chr(34) & FULLBBCODE & chr(34) Does that work? "Matt" <Matt(a)discussions.microsoft.com> wrote in message news:1CB86EBF-E265-486C-AC1B-2CF10BD60EE3(a)microsoft.com... > 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" <Matt(a)discussions.microsoft.com> wrote in message >> news:5A807E22-29AA-4474-A700-C6BE1510BF0D(a)microsoft.com... >> > 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. >> >> >>
From: Matt McMaster on 27 Aug 2007 12:22
Doesn't seem to work. I have figured out that I can put a cell reference in, like B2 & " " & B3, where B2 = AUD and B3 = Curncy, and this works. However I really didn't want to have to hardcode references in, I want the user to be able to change where this data is contained in the future if possible. Although for the sake of time I may just go that route. Any other ideas? "Zone" wrote: > How about chr(34) & FULLBBCODE & chr(34) > Does that work? > > "Matt" <Matt(a)discussions.microsoft.com> wrote in message > news:1CB86EBF-E265-486C-AC1B-2CF10BD60EE3(a)microsoft.com... > > 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" <Matt(a)discussions.microsoft.com> wrote in message > >> news:5A807E22-29AA-4474-A700-C6BE1510BF0D(a)microsoft.com... > >> > 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. > >> > >> > >> > > > |