ExcelBanter - DDE formula with variable

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - DDE formula with variable (https://www.excelbanter.com/excel-worksheet-functions/166339-dde-formula-variable.html)

Bruce

DDE formula with variable

I have a DDE formula which I wish to make the part "bhp" a variable in cell
A1. The working formula is as follows

=pulsesecurity|bhp!code

I have tried to replace with the following but I get errors

=concatenate(pulsesecurity|,A1,!code)

=concatenate("pulsesecurity|",A1,"!code")

What are some possible solutions?

Bruce

All times are GMT +1. The time now is 03:09 PM.