Microsoft KB Archive/43842

{| = Excel: GET.WINDOW(1,&quot;file&quot;) Returns #VALUE! If &quot;file&quot; Not Open =
 * width="100%"|

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,&quot;File1&quot;) will return #VALUE! if there is no document named &quot;File1&quot; currently opened.

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

KBSubcategory: kbother KBSubcategory:
 * }