Concatenating with a DDE link?

[billiboy]

Hi

I have a program named ontrade from which I bring stock prices to Excel through DDE links. For example, if the name of the stock is "SHB A", I bring its ask price through the formula:

=ontrade|quote!'SHB A&SSE.ask'

But I don't want to insert the name of the stock manually in the formula. I have tried entering "SHB A" in a cell, say A1, and writing:

=ontrade|quote!' &A1 &SSE.ask'

But it doesn't work. Do anyone know how I can do this?

[VBA Noob]

billiboy,

Please don't ignore Shg request to read the forum rules as you heading towards a ban for all your cross posting without the link

VBA Noob

[billiboy]

Sorry, now I know the rules.

I posted the same question one day later at another forum (mrExcel) because I didn't get any answer here but I should have included a link to my original question.

As for the answer to the question, it seems to be solvable using macros:

http://www.mrexcel.com/forum/showthr...56#post1697756