Excel: DDE Error When Sending End Command

Last reviewed: November 3, 1994
Article ID: Q79087

The information in this article applies to:

Microsoft Excel for Windows, versions 3.0, 4.0
Microsoft Excel for OS/2, version 3.0

SUMMARY

When extracting from an external database in Microsoft Excel versions 3.0 and 4.0 for Windows, the error "DDE Error when sending end command" occurs if the criteria range contains a numeric entry for a field defined as a character in the database.

MORE INFORMATION

This error occurs only when the external database is a text file, dBase file, or an SQL table.

Workaround

Enter the criteria as text. For example:

   ="1234"

REFERENCES

"Q+E for Microsoft Excel User's Guide," version 3.0, pages 57-71

KBCategory: kbusage
KBSubcategory:
Additional reference words: 3.00 3.0 4.0 4.00 message qe.xla q+e
qestart.xla qpluse q + e err msg

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.