INFO

Syntax:

INFO ( category )

Description: Retrieves the operating environment value that corresponds to category.

Arguments:

Name

Type

Description

category

text

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.

text

"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.

text

"osversion"

Current operating system version.

text

"recalc"

Current recalculation mode: "Automatic" or "Manual"

text

"release"

Version of the implementation.

text

"system"

Name of the operating environment.

text

"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("memused") might result in 1474464INFO("numfile") might result in 5INFO("origin") might result in $A:$C$536

INFO("osversion") might result in Windows (32-bit) NT 5.01INFO("recalc") might result in AutomaticINFO("release") might result in 11.0

INFO("system") might result in pcdosINFO("totmem") might result in 2523040]