Microsoft KB Archive/79087

{| = Excel: DDE Error When Sending End Command =
 * width="100%"|

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 &quot;DDE Error when sending end command&quot; 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:

=&quot;1234&quot;