Skip to content

Excel.QueryTable.FieldNames.md

Latest commit

 

History

History
45 lines (26 loc) · 1.29 KB

Excel.QueryTable.FieldNames.md

File metadata and controls

45 lines (26 loc) · 1.29 KB
title QueryTable.FieldNames property (Excel)
keywords vbaxl10.chm518074
f1_keywords
vbaxl10.chm518074
api_name
Excel.QueryTable.FieldNames
ms.assetid ff7541cd-fa4d-6b1a-d8c3-0608cfc03b8d
ms.date 05/03/2019
ms.localizationpriority medium

QueryTable.FieldNames property (Excel)

True if field names from the data source appear as column headings for the returned data. The default value is True. Read/write Boolean.

Syntax

expression.FieldNames

expression A variable that represents a QueryTable object.

Remarks

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 FieldNames property applies only to QueryTable objects.

Example

This example sets query table one so that the field names don't appear in it.

Worksheets(1).QueryTables(1).FieldNames = False

[!includeSupport and feedback]