Listing System Information Available Using Application Object Properties

Sub InspectTheEnvironment()

Debug.Print Application

Debug.Print Application

Debug.Print Application

Debug.Print Application

Debug.Print Application

Debug.Print Application

Debug.Print Application

Debug.Print Application End Sub

.CalculationVersion

.MemoryFree

.MemoryUsed

.MemoryTotal

.OperatingSystem

.OrganizationName

.UserName

.Version

This code produces the following output on my computer.

114210 1048576 475128 1523704

Windows (32-bit) NT 5.01 Dakota Technology Group, Inc. Steven M. Hansen 11.0

Table 5.2 details some of the system-oriented properties of the Application object.

Table 5.2: System-Oriented Properties of the Application Object

Property Name value Returned

CalculationVersion Right four digits indicate the version of the calculation engine whereas the digits to the left indicate the major version of Excel.

MemoryFree Returns the amount of memory in bytes that Excel is allowed to use, not including memory already in use.

Table 5.2: System-Oriented Properties of the Application Object (continued)

Property Name

MemoryUsed MemoryTotal

OperatingSystem OrganizationName UserName Version

Value Returned

Returns the amount of memory, in bytes, that Excel is currently using.

Returns the total amount of memory, in bytes, that Excel can use. It includes memory that is already in use. It is the sum of MemoryFree and MemoryUsed.

Returns the name and version of the Operating System.

Returns the name of the organization to which the product is registered.

Returns or sets the name of the current user.

Returns the version of Excel that is in use.

0 0

Post a comment