Programming Function
in [Programming]
|
Prev: rename message
Next: weight watchers quick tracker
From: Zone on 27 Aug 2007 12:47 Matt, can you just post your entire routine? I think we're missing something. James "Matt McMaster" <MattMcMaster(a)discussions.microsoft.com> wrote in message news:D8E0E2C3-F594-42AD-B4B7-4BEB28AF5BDA(a)microsoft.com... > 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. >> >> >> >> >> >> >> >> >>
From: Matt McMaster on 27 Aug 2007 13:06 Sure, Function Futures (BBCODE, BBKEY) FULLBBCODE = BBCODE & " " & BBKEY Futures = [BDP(FULLBBCODE, "Last Price")] End Function where BBCODE equals cell B2 = AUD and BBKEY equals cell B3 = Curncy BDP is the Bloomberg function that I'm using to return real-time market data. So I've tried the suggestions from earlier and none seem to make the function work. I can manually type in "AUD Curncy" in the function and it works, I can put B2 & " " & B3 manually and get it to work, and I've tried using the index function and that works. But of course what I really want is something close to what I've typed above, very frustrating. Any help is appreciated, thanks. "Zone" wrote: > Matt, can you just post your entire routine? I think we're missing > something. James > > "Matt McMaster" <MattMcMaster(a)discussions.microsoft.com> wrote in message > news:D8E0E2C3-F594-42AD-B4B7-4BEB28AF5BDA(a)microsoft.com... > > 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. > >> >> > >> >> > >> >> > >> > >> > >> > > >
From: Rick Rothstein (MVP - VB) on 27 Aug 2007 13:05 It might be a typo on your part, but let's go back to what you posted originally... > BDP("AUD Curncy","LAST_PRICE") > > BBCODE = AUD > BBKEY = Curncy > FULLBBCODE = BBCODE & BBKEY FULLBBCODE, as constructed, will not have the blank space between BBCODE and BBKEY. Try the assignment this way... FULLBBCODE = BBCODE & " " & BBKEY and see if that helps any. I'm thinking your code should look something like this... BBCODE = AUD BBKEY = Curncy FULLBBCODE = BBCODE & " " & BBKEY <<Function>> = "BDP(""" & FULLBBCODE & """,""LAST_PRICE"")" You used "Function" as a variable in your original posting... that is a reserved keyword and cannot be the name of a variable. Rick "Matt McMaster" <MattMcMaster(a)discussions.microsoft.com> wrote in message news:D8E0E2C3-F594-42AD-B4B7-4BEB28AF5BDA(a)microsoft.com... > 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. >> >> >> >> >> >> >> >> >>
From: Rick Rothstein (MVP - VB) on 27 Aug 2007 13:21 > Function Futures (BBCODE, BBKEY) > > FULLBBCODE = BBCODE & " " & BBKEY > Futures = [BDP(FULLBBCODE, "Last Price")] > > End Function > > where BBCODE equals cell B2 = AUD > and BBKEY equals cell B3 = Curncy What about this? Function Futures (BBCODE, BBKEY) FULLBBCODE = BBCODE & " " & BBKEY Futures = ["BDP(""" & FULLBBCODE & """,""LAST_PRICE"")"] End Function Rick
From: Matt McMaster on 27 Aug 2007 13:52
Sorry, still returns an error. As an alternative, is there anyway to use the reference supplied by the user. So instead of getting the value AUD, I get B2 and then I could use that? Matt "Rick Rothstein (MVP - VB)" wrote: > > Function Futures (BBCODE, BBKEY) > > > > FULLBBCODE = BBCODE & " " & BBKEY > > Futures = [BDP(FULLBBCODE, "Last Price")] > > > > End Function > > > > where BBCODE equals cell B2 = AUD > > and BBKEY equals cell B3 = Curncy > > What about this? > > Function Futures (BBCODE, BBKEY) > FULLBBCODE = BBCODE & " " & BBKEY > Futures = ["BDP(""" & FULLBBCODE & """,""LAST_PRICE"")"] > End Function > > Rick > |