Microsoft KB Archive/45473

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.