Microsoft KB Archive/45473: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (X010 moved page Microsoft KB Archive/Q45473 to Microsoft KB Archive/45473 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/") |
||
| (One intermediate revision by the same user not shown) | |||
| Line 15: | Line 15: | ||
The name bhpjo is a valid item in the DDE application. You cannot build the Advise statement with the following formula: | The name bhpjo is a valid item in the DDE application. You cannot build the Advise statement with the following formula: | ||
=server|topic!B1& | =server|topic!B1&B2 | ||
Copyright Microsoft Corporation 1993. | Copyright Microsoft Corporation 1993. | ||
Latest revision as of 19:23, 12 August 2020
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.
