Converting Text to Function

[Dan B]

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_UK]

This old thread might be of use to you:

http://groups.google.com/group/micr...8d38f?lnk=gst&q=eval+*excel*#70d3b9427478d38f

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

Hope this helps.

Pete

 

[Dan B]

Pete - thanks - that helps - Dan B

This old thread might be of use to you:

http://groups.google.com/group/micr...8d38f?lnk=gst&q=eval+*excel*#70d3b9427478d38f

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

Hope this helps.

Pete

 

[Pete_UK]

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

Pete