Hi, I'm new here and have a problemo. The CSV output from this butt-old mainframe system I use occassionally has rows of data so long that Excel can't import it all. I am unable to stop the mainframe from exporting the columns, so Excel has to stop it during the import. This is my current code. What I'm hoping for is a sort of "blanket" command to SKIP column 68 and beyond. (There can be hundreds beyond...)

ChDir "C:\AX\INPUT"
    Workbooks.OpenText Filename:="C:\AX\INPUT\ax", Origin:=437, StartRow:=1, _
        DataType:=xlDelimited, TextQualifier:=xlSingleQuote, ConsecutiveDelimiter _
        :=False, Tab:=False, Semicolon:=False, Comma:=True, Space:=False, _
        Other:=False, FieldInfo:=Array(Array(1, 2), Array(2, 2), Array(3, 2), Array(4, 1), _
        Array(5, 2), Array(6, 2), Array(7, 2), Array(8, 2), Array(9, 2), Array(10, 2), Array(11, 2), _
        Array(12, 2), Array(13, 2), Array(14, 2), Array(15, 2), Array(16, 2), Array(17, 2), Array( _
        18, 2), Array(19, 1), Array(20, 1), Array(21, 2), Array(22, 2), Array(23, 2), Array(24, 2), _
        Array(25, 2), Array(26, 2), Array(27, 2), Array(28, 2), Array(29, 2), Array(30, 2), Array( _
        31, 2), Array(32, 2), Array(33, 2), Array(36, 2), Array(37, 2), _
        Array(38, 2), Array(39, 2), Array(40, 2), Array(41, 2), Array(42, 1), Array(43, 2), Array( _
        44, 2), Array(45, 2), Array(46, 2), Array(47, 2), Array(48, 2), Array(49, 2), Array(50, 1), _
        Array(51, 2), Array(52, 2), Array(53, 2), Array(54, 2), Array(55, 2), Array(56, 2), Array( _
        57, 2), Array(58, 1), Array(59, 2), Array(60, 2), Array(61, 2), Array(62, 2), Array(63, 2), _
        Array(64, 2), Array(65, 2), Array(66, 1), Array(67, 2), Array(68, 9)), _
        TrailingMinusNumbers:=True
Oops, I just came back to add the CODE tags, but someone beat me to it. That was fast!