The information in this article applies to:
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.
CAUSEThis behavior is by design of the versions of Microsoft Excel listed at the beginning of this article. MORE INFORMATIONThe 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:
Additional query words: 97 greyed out
Keywords : |
Last Reviewed: July 29, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |