Q: DDE Link - Replace Part of the Formula  
Author Message

PostPosted: Top

worksheet functions >> Q: DDE Link - Replace Part of the Formula


I am successfully using the following formula to get real-time data from a
3rd party software into Excel:

=SAT|Realtime!'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

=SAT|Realtime!&"'"&A1&A2&".lio LastPrice'" would correctly return my value
but this doesn't work.

Any ideas?

Thanks in advance