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