XL5: GET.WORKBOOK(16) and GET.DOCUMENT(1) Not the Same

ID: Q111973

5.00 WINDOWS DocErr kbdocerr

The information in this article applies to:

- Microsoft Excel for Windows, version 5.0

SUMMARY

Microsoft Excel Help states that the GET.WORKBOOK(16) function is equivalent to GET.DOCUMENT(1). This information is incorrect.

The GET.WORKBOOK(16) function returns the name of the active workbook as text (for example, "Book1"). The GET.DOCUMENT(1) function, however, returns the name of the active sheet as text (for example, "[Book1]Sheet1") if there is more than one sheet in the workbook.

MORE INFORMATION

To find the description of the GET.WORKBOOK() function in Microsoft Excel Help, do the following:

1. From the Help menu, choose Contents.

2. Select Reference Information.

3. Under the General Reference section, select Microsoft Excel Macro

   Functions Contents.

4. Select Alphabetical List Of Macro Functions and choose GET.WORKBOOK from

   the list of functions.

KBCategory: kbdocerr KBSubcategory:

Additional reference words: 5.00 helpfile MACROFUN.HLP

Version           : 5.00
Platform          : WINDOWS

Last Reviewed: September 14, 1996