Saving a Previous Database Definition When Using QE.XLALast reviewed: November 3, 1994Article ID: Q68994 |
SUMMARYWith the add-in QE.XLA loaded, each time you choose Set Database from the Data menu and select the option Current Selection, the name DATABASE is defined as the current selection on the worksheet.
MORE INFORMATIONThis may be inconvenient if you frequently switch between an internal database, located on your worksheet, and external databases. To save the previous Database definition:
A1: =SELECT(!Database) A2: =DB.SET.DATABASE(TRUE) A3: =RETURN() REFERENCES"Q+E for Microsoft Excel User's Guide." Version 3.00, page 70
|
KBCategory: kbother
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |