TextConnection.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.

ActiveWorkbook.Connections(1).TextConnection.TextFileParseType = xlDelimited