FieldNames Property

Microsoft Excel Visual Basic

FieldNames Property

       

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

Example

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

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