The Excel Info function returns a text string containing information about the current operating environment.
Where the type_text argument is a text string that specifies the type of information to be returned.
|"directory"||Path of the current directory|
|"numfile"||The number of active worksheets in all currently open Excel Workbooks|
|"origin"||Returns the top left cell reference of the current worksheet (generally A1) and the top left cell that is currently visible in the scrolled area of the current worksheet.|
|"osversion"||Current operating system version|
|"recalc"||Current recalculation mode (either "Automatic" or "Manual")|
|"release"||Current version of Microsoft Excel|
|"system"||Current operating environment ("mac" = Macintosh or "pcdos" = Windows)|
The following spreadsheet contains five examples of the Excel Info function.
Note that the examples were run on a Windows operating system. The Info function may return different results on other operating systems.
Further details and examples of the Excel Info function are provided on the Microsoft Office website.
If you get an error from the Excel Info function this is likely to be one of the following:
|#N/A!||-||Occurs if the type_text argument is "memavail" or "memused" (used in old versions of Excel, but no longer supported).|
|#VALUE!||-||Occurs if the type_text argument is any other invalid value.|