reference to a cell within a string
 

I have written the following:

If [b2] = 5 Then [b3] = "blp(""GE Equity"",""Last Price"")"
Else [b3] = ""

giving me the wanted result: blp("GE Equity","Last Price")

My question is, lets say I would like to reference cell [b4] = IBM, in
order to replace GE in this string.

to give me the result: blp("IBM Equity","Last Price")

Thank you,

Susan

reference to a cell within a string
 

If [b2] = 5 Then [b3] = "blp(""" & "[b4] & " Equity"",""Last Price"")"

"susan hayes" wrote:

I have written the following:

If [b2] = 5 Then [b3] = "blp(""GE Equity"",""Last Price"")"
Else [b3] = ""

giving me the wanted result: blp("GE Equity","Last Price")

My question is, lets say I would like to reference cell [b4] = IBM, in
order to replace GE in this string.

to give me the result: blp("IBM Equity","Last Price")

Thank you,

Susan

reference to a cell within a string
 

Yikes! Just noticed a typo.
should be:
"blp(""" & [b4] & " Equity"",""Last Price"")"

"K Dales" wrote:

If [b2] = 5 Then [b3] = "blp(""" & "[b4] & " Equity"",""Last Price"")"

"susan hayes" wrote:

I have written the following:

If [b2] = 5 Then [b3] = "blp(""GE Equity"",""Last Price"")"
Else [b3] = ""

giving me the wanted result: blp("GE Equity","Last Price")

My question is, lets say I would like to reference cell [b4] = IBM, in
order to replace GE in this string.

to give me the result: blp("IBM Equity","Last Price")

Thank you,

Susan

reference to a cell within a string [Bloomberg lookup]
 

Have a look at
http://www.sulprobil.com/html/early_warning_system.html

But I think now it is better to use ActiveX than bpl()
functions.

Kind regards,
sulprobil