DDE link formula substitution

[jpmaher]

Hello All.

I have a problem with a DDE link formula that I want to substitute part of it with a text value in a cell. This is the formula

=RSLINX|Area_2_PLC_1!'LHVA_3154TF_C.Auto_Mode,L1,C1'

I'm trying to replace the "Area_2_PLC_1" with a value in cell A1 and "LHVA_3154TF" with a value in Cell A2.

Can anyone help?

Thanks in advance.

Joe.

[swatsp0p]

Untested, but you can try the '&' to concatenate your formula as such:

=RSLINX|A1&'A2&_C.Auto_Mode,L1,C 1'


Good Luck

Bruce

[jpmaher]

Hi Bruce.

Thanks but it did not work I tried doing it a few diffrent ways with no luck, any other ideas?

Thanks.

Joe.

[swatsp0p]

As I am unfamiliar with the "=RSLINX" function (user defined?) I can't be of anymore help. Sorry.

I do, however, notice that your sample formula uses single quotes. You may want to experiment with moving them around the & and the cell references to see if that meets the syntax requirements.

Study your original syntax and try to duplicate the punctuation in your modified formula. If your cell reference is a number, it may need to be text or vice versa.

Just some thoughts....

Good Luck

Bruce

[jpmaher]

Thanks Bruce.

I'll play around.

[jpmaher]

Can anyone else help on this?

Thanks.

[swatsp0p]

Just another thought, try using the INDIRECT function to refer to the cell that contains the reference...

Good Luck

Bruce

[jpmaher]

Thanks Bruce I'll give it a go.

Regards
Joe.