I have a DDE link in the following format: =TOS|LAST!IBM

This represents a command to go to a broker (TOS) and pickup the last trade
price for IBM. When I try to convert the function to text and do a
automatic replace of IBM with another stock symbol, such as MSFT, I cannot
get the resulting text to convert back to a DDE function. Is there some
command whereby I can instruct the cell to add an = sign and convert the text
to a function?

Thank you

This old thread might be of use to you:

http://groups.google.com/group/micro...b94274 78d38f

Setting up a UDF called Eval allows you to pass a string to be
evaluated.

Hope this helps.

Pete

On May 21, 4:18*am, Dan B <Dan wrote:
I have a DDE link in the following format: *=TOS|LAST!IBM

This represents a command to go to a broker (TOS) and pickup the last trade
price for IBM. * When I try to convert the function to text and do a
automatic replace of IBM with another stock symbol, such as MSFT, I cannot
get the resulting text to convert back to a DDE function. * Is there some
command whereby I can instruct the cell to add an = sign and convert the text
to a function?

Thank you

Pete - thanks - that helps - Dan B

"Pete_UK" wrote:

This old thread might be of use to you:

http://groups.google.com/group/micro...b94274 78d38f

Setting up a UDF called Eval allows you to pass a string to be
evaluated.

Hope this helps.

Pete

On May 21, 4:18 am, Dan B <Dan wrote:
I have a DDE link in the following format: =TOS|LAST!IBM

This represents a command to go to a broker (TOS) and pickup the last trade
price for IBM. When I try to convert the function to text and do a
automatic replace of IBM with another stock symbol, such as MSFT, I cannot
get the resulting text to convert back to a DDE function. Is there some
command whereby I can instruct the cell to add an = sign and convert the text
to a function?

Thank you

You're welcome, Dan - thanks for feeding back.

Pete

On May 21, 10:20*am, Dan B wrote:
Pete - thanks - that helps - Dan B