Microsoft Office Tutorials and References
In Depth Information
Getting Information about Excel and Your Computer System
Getting Information about Excel
and Your Computer System
Excel provides the INFO function to get information about your computer and
about the program itself. INFO takes a single argument that tells the function
what type of information to return. Table 15-3 shows how to use the INFO
function.
Table 15-3
Using INFO to Find Out about Your Computer or Excel
Argument
Example
Comment
Returns the path of the current
directory. Note that this is not
necessarily the same path of
the open workbook.
directory
=INFO(“directory”)
Numfile
=INFO(“numfile”)
Returns the number of
worksheets in all open workbooks.
Includes worksheets of
addins, so the number could be
misleading.
origin
=INFO(“origin”)
Returns the address of the cell
at the top and to the left of the
scrollable area. An A$ prefix in
front of the cell address is for
compatibility with Lotus 1-2-3.
osversion
=INFO(“osversion”)
Returns the name of the
current operating system.
recalc
=INFO(“recalc”)
Returns the status of the
recalculation mode: either
Automatic or Manual .
release
=INFO(“release”)
Returns the version number of
Excel being run.
Returns the name of the
operating environment: either mac
or pcdos.
system
=INFO(“system”)
Search JabSto ::




Custom Search