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 .
expression A variable that represents a QueryTable 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 FieldNames property applies only to QueryTable objects.
This example sets query table one so that the field names don't appear in it.
Worksheets(1).QueryTables(1).FieldNames = False