Microsoft Knowledge Base
Excel: Type_num Required with DOCUMENTS()
Last reviewed: September 12, 1996
Article ID: Q102864
The information in this article applies to:
- Microsoft Excel for Windows, versions 4.0, 4.0a
- Microsoft Excel for the Macintosh, version 4.0
SUMMARY
On pages 118 and 460 of the "Function Reference," version 4.0, the type_num arguments in the DOCUMENTS() and WINDOWS() functions are not bold, indicating that the argument is not required.
This information is incorrect: when you use the match_text argument, type_num is a required argument for both the DOCUMENTS() and WINDOWS() functions if wildcards are present in the match_text argument.
MORE INFORMATION
If the type_num argument is not present when you use wildcard characters in the match_text argument, the DOCUMENTS() and WINDOWS() functions will return an #N/A error value.
Examples:
=DOCUMENTS(,"aa.*") =DOCUMENTS(,"*.*") =WINDOWS(,"aa.*") =WINDOWS(,"*.*")
If the type_num argument is not present when you are using a valid document name with the DOCUMENTS() function, the formula will return an #N/A error value.
Example:
=DOCUMENTS(,"Sheet1.xls")
REFERENCES
"Function Reference," version 4.0, pages 118, 460
KBCategory: kbdocerr Last reviewed: September 12, 1996 |