tilamok
06-10-2010, 04:25 AM
Hi All
I have the following code in an excel macro and I wish to move it all to Access using specsfiles. However I can't make heads or tails as to how this array code works. It seems to be doing an array of an array.
Also 1st it uses (0,9) then (1,1) then (8,1), please help me interpret how this works.
Many Thanks
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 9), Array(1, 1), Array(8, 1), Array(15, 1), Array(17, 1), _
Array(18, 1), Array(20, 1), Array(21, 1), Array(36, 1), Array(37, 1), Array(52, 1), Array( _
57, 1), Array(58, 1), Array(60, 1), Array(62, 1), Array(64, 1), Array(71, 1), Array(78, 1), _
Array(81, 4), Array(89, 1), Array(90, 1), Array(91, 1), Array(92, 1), Array(98, 1), Array( _
99, 2), Array(103, 2), Array(115, 2), Array(127, 2), Array(153, 2), Array(185, 2), Array(217, 2), _
Array(249, 2), Array(269, 2), Array(278, 4), Array(286, 4), Array(294, 1))
I have the following code in an excel macro and I wish to move it all to Access using specsfiles. However I can't make heads or tails as to how this array code works. It seems to be doing an array of an array.
Also 1st it uses (0,9) then (1,1) then (8,1), please help me interpret how this works.
Many Thanks
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlFixedWidth, _
FieldInfo:=Array(Array(0, 9), Array(1, 1), Array(8, 1), Array(15, 1), Array(17, 1), _
Array(18, 1), Array(20, 1), Array(21, 1), Array(36, 1), Array(37, 1), Array(52, 1), Array( _
57, 1), Array(58, 1), Array(60, 1), Array(62, 1), Array(64, 1), Array(71, 1), Array(78, 1), _
Array(81, 4), Array(89, 1), Array(90, 1), Array(91, 1), Array(92, 1), Array(98, 1), Array( _
99, 2), Array(103, 2), Array(115, 2), Array(127, 2), Array(153, 2), Array(185, 2), Array(217, 2), _
Array(249, 2), Array(269, 2), Array(278, 4), Array(286, 4), Array(294, 1))