XL: COMPARE.XLA Only Works in Microsoft Excel 4.0

 Last reviewed: February 2, 1998
Article ID: Q122330
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel 97 for Windows
  • Microsoft Excel 98 Macintosh Edition

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.

STATUS

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, choose the search button in Reference Information Help and type: 

   GET.DOCUMENT
"Function Reference," version 4.0, pages 196-199 "User's Guide 2," version 4.0, page 201

Additional query words: 98 97 7.00 5.00 greyed out
Version : WINDOWS:5.0;5.0c;7.0,97; MACINTOSH:5.0,5.0a,98
Platform : MACINTOSH WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.