Get information about current environment
The information requested
- type_text – The information type to return as text.
The INFO function can retrieve information about the current environment, including OS, OS version, Excel version, and so on. To use the INFO function, supply the type of information you want as text. There are seven types of information you can request:
|directory||Path of the current directory or folder|
|numfile||Number of active worksheets in open workbooks|
|origin||First visible cell at upper left|
|osversion||Operating system version|
|system||Operating system name|
Note that INFO is a volatile function and will update each time a change is made to the worksheet.