Microsoft KB Archive/117597

= Microsoft Knowledge Base =

XL: GET.DOCUMENT(68) Always Returns Workbook Name
Last reviewed: March 27, 1997

Article ID: Q117597

5.00 5.00c 7.00 7.00a | 5.00 5.00a

WINDOWS              | MACINTOSH

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 95, versions 7.0, 7.0a

SUMMARY
In Microsoft Excel, the macro command GET.DOCUMENT(68) will always return the name of the workbook that contains the specified document.

MORE INFORMATION
In Microsoft Excel Macro Functions Help, the information for GET.DOCUMENT states the following

68  Microsoft Excel 5.0 always returns the book name. This statement is true because in Microsoft Excel versions 5.0 and 7.0, documents are always considered part of workbooks, and cannot be shared between different workbooks, as is possible in Microsoft Excel version 4.0.

In Microsoft Excel version 4.0, the GET.DOCUMENT(68)command returns any of three possible values:

Value                    Definition Workbook Name            The document is bound into a single workbook

Array of Workbook Names  The document is unbound and is contained in                          each workbook listed in the array

Because all documents in Microsoft Excel versions 5.0 and 7.0 are bound into a single workbook, the only possible value that can be returned is the name of the single workbook that contains the document.
 * 1) N/A                     The document is not contained in a workbook