TextConnection.TextFileParseType procedure builder

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