Returns text with one of several different meanings, depending on the object type to which it’s applied. Read/write String, except as noted in the following table.
| Object type | Meaning |
|---|---|
| Application | The name that appears in the title bar of the main Microsoft Excel window. If you don't set a name, or if you set the name to Empty, this property returns "Microsoft Excel". |
| AxisTitle | The axis title text. |
| Characters | The text of this range of characters. |
| ChartTitle | The chart title text. |
| CubeField, PivotItem, PivotField | The label text for the cube field, PivotTable field, or PivotTable item. |
| DataLabel | The data label text. |
| Window | The name that appears in the title bar of the document window. When you set the name, you can use that name as the index to the Windows property (see the second example). |
The following table shows example values of the Caption property and related properties, given an OLAP data source with the unique name "[Europe].[France].[Paris]" and a non-OLAP data source with the item name "Paris".
| Property | Value (OLAP data source) | Value (non-OLAP data source) |
|---|---|---|
| Caption | Paris | Paris |
| Name | [Europe].[France].[Paris] (read-only) | Paris |
| SourceName | [Europe].[France].[Paris] (read-only) | (Same as the SQL property value; read-only) |
| Value | [Europe].[France].[Paris] (read-only) | Paris |
When specifying an index into the PivotItems collection, you can use the syntax shown in the following table.
| Syntax (OLAP data source) | Syntax (non-OLAP data source) |
|---|---|
| expression.PivotItems("[Europe].[France].[Paris]") | expression.PivotItems("Paris") |
When using the Item property to reference a specific member of a collection, you can use the text index names shown in the following table.
| Name (OLAP data source) | Name (non-OLAP data source) |
|---|---|
| [Europe].[France].[Paris] | Paris |