Microsoft KB Archive/102864

= 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")