Microsoft KB Archive/43842

From BetaArchive Wiki


Excel: GET.WINDOW(1,"file") Returns #VALUE! If "file" Not Open

Last reviewed: October 31, 1994
Article ID: Q43842

SUMMARY

In Microsoft Excel versions 2.20 and 3.00, the GET.WINDOW command returns #VALUE! if the indicated file is not currently open. This is different from Microsoft Excel 1.50, which returned a value of 0 (zero) if the file was not open.

For example, in Excel 2.20 and 3.00, GET.WINDOW(1,"File1") will return #VALUE! if there is no document named "File1" currently opened.

In Excel 1.50, GET.WINDOW(1,"File1") will return the value 0 (zero) if there is no document named "File1" currently opened.

KBSubcategory: kbother KBSubcategory:


Additional reference words: 2.20 3.00



Last reviewed: October 31, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.