QueryTable.Name Property (Excel)
Returns or sets a String value representing the name of the object.
Syntax
expression .Name
expression A variable that represents a QueryTable object.
Remarks
The following table shows example values of the Name 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 SQL property value, read-only) |
Value |
[Europe].[France].[Paris] (read-only) |
Paris |
If you import data using the user interface, data from a Web query or a text query is imported as a QueryTable object, while all other external data is imported as a ListObject object.
If you import data using the object model, data from a Web query or a text query must be imported as a QueryTable, while all other external data can be imported as either a ListObject or a QueryTable.
The Name property applies only to QueryTable objects.