COMPARE.XLA Only Works in Microsoft Excel 4.0
Article ID: 122330
Article Last Modified on 8/15/2005
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
This article was previously published under Q122330
SYMPTOMS
Some add-ins that are available in Microsoft Excel version 4.0 are not
included with the versions of Microsoft Excel listed at the beginning of
this article. For example, the COMPARE.XLA add-in (WORKSHEET COMPARISON in
Microsoft Excel for the Macintosh) is not included in Microsoft Excel
versions 5.0 and later.
If you use the Microsoft Excel version 4.0 COMPARE.XLA add-in in the
versions of Microsoft Excel listed at the beginning of the article, it
will not run correctly: when COMPARE.XLA (or WORKSHEET COMPARISON on the
Macintosh) is used in Microsoft Excel version 5.0 or later, the OK button
is unavailable (dimmed) after you select the sheet to be compared.
CAUSE
This behavior is by design of the versions of Microsoft Excel listed at
the beginning of this article.
MORE INFORMATION
The GET.DOCUMENT() command in the versions of Microsoft Excel listed at
the beginning of the article is different from the GET.DOCUMENT() function
in 4.0. In Microsoft Excel version 4.0, GET.DOCUMENT(3) returns 5 if the
document is a workbook. In Microsoft Excel version 5.0, GET.DOCUMENT(3)
does not check for a workbook file type because all files in Microsoft
Excel version 5.0 are workbooks. The Type_Num 5 is marked as reserved.
Because of this, the error checking in the add-in does not allow the macro
to proceed.
REFERENCES
For more information about the GET.DOCUMENT() function, click the Search
button in Reference Information Help and type:
"Function Reference," version 4.0, pages 196-199
"User's Guide 2," version 4.0, page 201
Additional query words: 97 greyed out XL
Keywords: KB122330