Use of Concatenation with DDE in Excel Advise PSS ID Number: Q45473 Article last modified on 02-26-1993 PSS database name: W_eXceL
2.00 2.01 2.10 2.10c 2.10d 3.00 3.00a | 2.20 2.21 3.00
WINDOWS | OS/2
Summary:
In Excel, it is not possible to use concatenation to build a DDE Advise formula of the form =server|topic!item. The actual names must be used for the server, topic and item.
For example:
In cell B1 is the string bhp In cell B2 is the string jo
The name bhpjo is a valid item in the DDE application. You cannot build the Advise statement with the following formula:
=server|topic!B1&B2
Copyright Microsoft Corporation 1993.