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

#N/A                      The document is not contained in a workbook
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.

REFERENCES

"Function Reference," version 4.0, page 199

KBCategory:
KBSubcategory:

Additional reference words: 5.00 7.00
Version : 5.00 5.00c 7.00 7.00a | 5.00 5.0
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: March 27, 1997
©1997 Microsoft Corporation. All rights reserved. Legal Notices.