Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Information > INFO
 

INFO(type_text)

 
 Returns useful information about the environment.

 type_textThe text specifying what type of information you want returned:
"directory" = the path of the current directory or folder
"memavail" = the amount of memory available in bytes
"memused" = the amount of memory currently being used in bytes
"numfile" = the number of active worksheets in the open workbooks
"origin" = the cell reference of the top leftmost cell visible in the current window, based on the current scolling position
"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
"totmem" = the total amount of memory in bytes

 REMARKS
 
  		• The function INFO("numfile") will return the total number of worksheets from all the workbooks that are currently open.

     EXAMPLES
     
     A
    1=INFO("directory") = C:\Temp\
    2=INFO("memavail")/1000000 &"Gb" = 1.048576Gb
    3=INFO("memused")/1000000 &"Gb" = 2.849728Gb
    4=INFO("numfile") = 5
    5=INFO("origin") = $A:$A$1
    6=INFO("osversion") = Windows (32-bit) NT 5.01
    7=INFO("recalc") = Automatic
    8=INFO("release") = 11.0
    9=INFO("system") = pcdos
    10=INFO("totmem")/1000000 &"Gb" = 3.898304Gb
    		 
     Functions - I | Index - I | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top