Q: DDE Link - Replace Part of the Formula

R

Reto Walker

Hi

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

Regards,

Reto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DDE Link in MS Access 0
Problem using IF statement with dates as part of the formula 4
Extracting a Part of a Formula as Text 5
Looking for the correct excel formula 2
Attn: Luke - followup to the 4 IF's from Friday 10
How to set formula for poping up the date of next Wednesday.... 2
Count the number of workday in a month 5
Copy part of VLOOKUP formula? 4

Top