All info file

Maurizio

Well-known Member
Joined
Oct 15, 2002
Messages
682
Office Version
  1. 2007
Platform
  1. Windows
Is there a way to print on a sheet all info on a my file *.xls:

Version
Build
Properties
etc.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
INFO(type_text)

Type_text is text that specifies what type of information you want returned.

Type_text Returns
"directory" Path of the current directory or folder.
"memavail" Amount of memory available, in bytes.
"memused" Amount of memory being used for data.
"numfile" Number of active worksheets in the open workbooks.
"origin" Absolute A1-style reference, as text, prepended with "$A:" for Lotus 1-2-3 release 3.x compatibility. Returns the cell reference of the top and leftmost cell visible in the window, based on the current scrolling position.
"osversion" Current operating system version, as text.
"recalc" Current recalculation mode; returns "Automatic" or "Manual".
"release" Version of Microsoft Excel, as text.
"system" Name of the operating environment:
Macintosh = "mac"
Windows = "pcdos"
"totmem" Total memory available, including memory already in use, in bytes.

Example
The example may be easier to understand if you copy it to a blank worksheet.

How?

Create a blank workbook or worksheet.
Select the example in the Help topic. Do not select the row or column headers.


Selecting an example from Help

Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.


1
2
A B
Formula Description (Result)
=INFO("numfile") Number of active worksheets (varies)
=INFO("recalc") Recalculation mode for the workbook (Automatic or Manual)
 

Forum statistics

Threads
1,143,709
Messages
5,720,390
Members
422,282
Latest member
psunith

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top