Microsoft KB Archive/77498

{|
 * width="100%"|

Excel Err Msg: QE.XLA Error Messages
'Article ID: Q77498

Creation Date: 17-OCT-1991

Revision Date: 04-NOV-1994' 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

The following error messages may be returned when running the QE.XLA add-in macro with Microsoft Excel.

For more information about the add-in macros, please refer to Appendix B in the &quot;Microsoft Excel User's Guide,&quot; version 3.0 for Windows manual. If you are using version 4.0, see pages 197-202 in the &quot;Microsoft Excel User's Guide 2.&quot; You may also search for Macro Library in the on-screen Help.

MORE INFORMATION

The following error message may be received in Microsoft Excel version 4.0 when you are running QE.XLA and attempt to paste information:


 * Cannot paste from Q+E. Check to insure the spreadsheet is not protected.

Additional error messages which may be seen include:
 * External database is not defined.
 * Extract range is not valid.
 * Criteria is not allowed on text or image fields:
 * Criteria values for binary fields must begin with 0x:
 * Error connecting to Q+E.
 * The current Excel selection is an object which is not valid for that operation.
 * Extract range is full.
 * SELECT statement is not valid.
 * DDE Error saving file.
 * Database is not defined.
 * Database is not valid.
 * DDE Error getting field definitions.
 * DDE Error when sending command.
 * DDE Error when sending end command.
 * Not enough room to paste all the selected fields. Paste as many as possible?
 * The command is not available for External Databases. Refer to the Q+E Data Form.
 * The command is not available for External Databases. Refer to the Q+E Data Find.
 * Unable to paste all records from Q+E. Make sure document is not protected.
 * Fetch of sources list failed.
 * Can't paste to cells which are locked or part of an array.
 * Delete operation failed.
 * Fetch of users list failed.
 * Fetch of logons list failed.
 * Fetch of logoffs list failed.
 * Can't load dll function.
 * Can't Find File:
 * Data will permanently be deleted.
 * Can't Connect to File:
 * No data retrieved.
 * SQL statement is not valid or DDE error.
 * Invalid File for Current Source:
 * Not a valid source.
 * Q+E could not be found. Make sure Q+E is installed in a directory included in your path.
 * The current Excel selection cannot be set as a database. Please select a single data range and try again.
 * Invalid Source:
 * Can't paste over objects.
 * Invalid Field:
 * Text and Image datatypes may not be selected as Distinct:
 * The file exists. Do you want to replace it?
 * Invalid Filename:
 * Can't perform that operation on protected worksheets.
 * Fixed Length Value Files will be brought in as a single column.
 * Can't perform that operation while in Workgroup mode.
 * Must use tablename.FIELDNAME when connected to multiple database tables.
 * Error in Criteria.
 * Fields may not be blank or zero.
 * Unable to log on to source:
 * Q+E Add-in must be named
 * Invalid database for current user:
 * Error on Set Database
 * Error on Data Form
 * Error on Data Find
 * SQL Statement too complex to record
 * Error on Data Extract
 * Error on Data Delete
 * Error Activating Q+E
 * Error on Paste Fieldnames
 * Error in SQL Statement

REFERENCES

&quot;Microsoft Excel User's Guide 2,&quot; version 4.0, pages 197-202

&quot;Microsoft Excel User's Guide,&quot; version 3.0, appendix B

AUDIT.XLA, Microsoft Excel version 3.0, EXCEL\LIBRARY subdirectory
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; 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." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

KBCategory: kberrmsg

KBSubcategory:

Additional reference words: 3.0 3.00 4.0 4.00