Example in Q+E Manual may Return #REF! Error in Q+E

Last reviewed: November 8, 1994
Article ID: Q88982

The information in this article applies to:

Microsoft Excel for Windows, version 3.0

SUMMARY

The examples on pages 80 through 83 in the "Q+E for Microsoft Excel User's Guide" could return the error message #REF! if the default directory not set to the QE sub-directory in the EXCEL directory. This error message is returned because the path to the EMP.DBF is not included.

MORE INFORMATION

In order for the examples to run without changing the directory, you should include the path. In Example 1 on page 80, for example, you would change

=EXECUTE(chan,"[OPEN('SELECT FIRST_NAME,LAST_NAME FROM EMP.DBF')]")

to:

=EXECUTE(CHAN,"[OPEN('SELECT FIRST_NAME,LAST_NAME FROM DBASEFILE | C:\EXCEL\QE\EMP.DBF')]")

REFERENCES

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

KBCategory: kbdocerr
KBSubcategory:
Additional reference words: 3.0 3.00 Docerror manual

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 8, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.