worksheet functions >> Q: DDE Link  Replace Part of the Formula
Hi
I am successfully using the following formula to get realtime data from a
3rd party software into Excel:
=SATRealtime!'ESX6O5375.lio LastPrice'
I was hoping to manually put in part of the formula in various cells and
then cross reference those instead of hardcoding these figures into the
formula as shown above:
By way of example, ESX6O might be in cell A1 and 5375 in cell A2
I was hoping that in the above scenario
=SATRealtime!&"'"&A1&A2&".lio LastPrice'" would correctly return my value
but this doesn't work.
Any ideas?
Thanks in advance
Regards,
Reto
Excel364
