Skip to content

Latest commit

 

History

History
45 lines (28 loc) · 1.59 KB

Excel.QueryTable.Name.md

File metadata and controls

45 lines (28 loc) · 1.59 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
QueryTable.Name property (Excel)
vbaxl10.chm518073
vbaxl10.chm518073
Excel.QueryTable.Name
56001390-df2e-b28a-6567-786453424f38
05/03/2019
medium

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 the SQL property value (read-only)
Value [Europe].[France].[Paris]  (read-only) Paris

If you import data by 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 by 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.

[!includeSupport and feedback]