Help needed with Text to column Excel macro.

[akssingh400]

He friends i have a macro for converting a text file into columnar format. I was curious about its working so checked its code and i have few doubt hopefully it will get cleared here

Public Sub Text_2_column()
'
' Text_2_column Macro
'

    
    Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
        TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
        Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo _
        :=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), _ 
    Array(7, 1), Array(8, 1), Array(9, 1)), TrailingMinusNumbers:=True
End Sub

I have a query

what does
:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), _
Array(7, 1), Array(8, 1), Array(9, 1)),
do? and the code works fine even without it....

 

[Samcos]

I have read the reply, but could somebody tell me if Excel starter incorporates the "Text to Column" function, and id so where do I find it.