Version property as it applies to the PivotTable object.
Returns the Microsoft Excel version number. Read-only 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 & "!"