Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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