Microsoft KB Archive/88982

{| = Example in Q+E Manual may Return #REF! Error in Q+E =
 * width="100%"|

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 &quot;Q+E for Microsoft Excel User's Guide&quot; 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,&quot;[OPEN('SELECT FIRST_NAME,LAST_NAME FROM EMP.DBF')]&quot;)

to:

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