The help files seem to indicate something like this to be inserted after the
code to define the qryTable:

With qryTable
.TextFileParseType = xlFixedWidth
.TextFileFixedColumnWidths = Array(5, 4) 'this is the column widths in
characters
.TextFileColumnDataTypes = _
Array(xlTextFormat, xlSkipColumn, xlGeneralFormat)
.Refresh
End With