Returns the text string returning useful information about the environment.
|type_text||The text specifying what type of information you want returned:|
"directory" = the path of the current directory or folder
"numfile" = the number of active worksheets in the open workbooks
"origin" = the first visible cell in upper left corner
"osversion" = the current operating system version
"recalc" = the current recalcation mode, either automatic or manual
"release" = the current release version of Microsoft Excel
"system" = the current name of the operating system
"memavail" (Removed in 2007) = the amount of memory available in bytes
"memused" (Removed in 2007) = the amount of memory currently being used in bytes
"totmem" (Removed in 2007) = the total amount of memory in bytes
|* This function is Volatile and will change everytime a cell on the worksheet is calculated.|
* If "type_text" = "numfile", then will return the total number of worksheets from all the workbooks that are currently open, including add-ins and hidden workbooks like Personal.xlsb.
* If "type_text" = "origin", then the cell reference of the top leftmost cell visible in the current window, based on the current scrolling position.
* If "type_text" = "system", then a Windows operating system will return "pcdocs" and a Macintosh system will return "mac".
* For the Microsoft documentation refer to support.office.com
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top