QueryTable.TextFileParseType (Excel)

Returns or sets the column format for the data in the text file that you are importing into a query table. Possible return values are xlDelimited - Default. Indicates that the file is delimited by delimiter characters, xlFixedWidth - Indicates that the data in the file is arranged in columns of fixed widths.

Use this property only when your query table is based on data from a text file (with the QueryType property set to xlTextImport). 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 TextFileParseType property applies only to QueryTable objects.

ActiveCell.QueryTable.TextFileParseType = xlDelimited