Version Property [Excel 2003 VBA Language Reference]

  • Article

Version property as it applies to the PivotTable object.

XlPivotTableVersionList

XlPivotTableVersionList can be one of these XlPivotTableVersionList constants.
xlPivotTableVersion10
xlPivotTableVersion2000
xlPivotTableVersionCurrent

expression.Version

expression Required. An expression that returns one of the above objects.

Version property as it applies to the Application object.

Returns the Microsoft Excel version number. Read-only String.

expression.Version

expression Required. An expression that returns one of the above objects.

Example

As it applies to the Application object.

This example displays a message box that contains the Microsoft Excel version number and the name of the operating system.

MsgBox "Welcome to Microsoft Excel version " & _ 
    Application.Version & " running on " & _
    Application.OperatingSystem & "!"

Applies to | Application Object | PivotTable Object

See Also | Build Property