Excel: ERROR(FALSE) with DDE Does Not Reset ERROR(TRUE)

 Last reviewed: November 3, 1994
Article ID: Q78868
Summary:

If you initiate a dynamic data exchange (DDE) connection to a second copy of Microsoft Excel for the Macintosh and you use the EXECUTE macro function to send an ERROR(FALSE) command to the second copy, error display remains disabled on the second copy of Excel after the DDE connection is terminated. This can result in unexpected behavior when you use the second copy of Excel.

To enable error display on the second copy of Excel, quit and restart Excel, or create a macro that runs the following macro statement: 

  =ERROR(TRUE)
More Information:

To avoid creating this problem in the original macro, send an ERROR(TRUE) command to the second copy of Excel before terminating the DDE connection with the following macro command: 

   =EXECUTE(chan,"[=error(true)]")
In the above command, chan is the DDE channel previously established in an INITIATE command.

Note: Using DDE with Excel requires System version 7.0 or higher.

Reference(s):

"Microsoft Excel User's Guide," version 3.0, pages 337-40 "Microsoft Excel Function Reference," version 3.0, page 68

KBCategory: kbother
KBSubcategory:

Additional reference words: 3.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.