On Excel, I have a DDE formula on B1 which reads
I want to change the formula so that
someText is written on A1 and then reference it on the DDE formula. Something like
I have tried to concatenate "A1" directly on the formula, as it is above, with no success.
Some other things I tried were
=server|info!indirect(A1)&".data", but had no success.
Is there a way to achieve this? How?