[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
INFO ( category )
Description: Retrieves the operating environment value that corresponds to category.
Arguments:
|
Name |
Type |
Description |
|
category |
The string designated by category is not case-sensitive. The valid strings are shown in the table below. |
|
category |
Meaning |
Result Type |
|
"directory" |
Path of the current directory or folder. | |
|
"memavail" |
Amount of memory available, in bytes. |
number |
|
"memused" |
Amount of memory being used for data. |
number |
|
"numfile" |
Number of active worksheets in the open workbooks. |
number |
|
"origin" |
The absolute cell reference of the top and leftmost cell visible in the window, based on the current scrolling position, prefixed with "$A:". [Example: Using cell D9 as an example, the return value would be $A:$D$9. end example] | |
|
"osversion" |
Current operating system version. | |
|
"recalc" |
Current recalculation mode: "Automatic" or "Manual" | |
|
"release" |
Version of the implementation. | |
|
"system" |
Name of the operating environment. | |
|
"totmem" |
Total memory available, including memory already in use, in bytes. |
number |
Return Type and Value: text – The operating environment value that corresponds to category.
However, if category is not one of the values defined above, #VALUE! is returned.
[Example:
INFO("directory") might result in e:\My Documents\
INFO(A10) might result in e:\My Documents\, where A10 contains directory
INFO("memavail") might result in 1048576
INFO("memused") might result in 1474464
INFO("numfile") might result in 5
INFO("origin") might result in $A:$C$536
INFO("osversion") might result in Windows (32-bit) NT 5.01
INFO("recalc") might result in Automatic
INFO("release") might result in 11.0
INFO("system") might result in pcdos
INFO("totmem") might result in 2523040
end example]