Microsoft KB Archive/45473

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.