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

ID: Q111973

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.


Additional query words: helpfile MACROFUN.HLP

Keywords :
Version : 5.00
Platform : WINDOWS
Issue type :


Last Reviewed: September 15, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.