Help needed with Text to column Excel macro.

A

akssingh400

Joined
Apr 17, 2012
Messages
1
Reaction score
0
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


Code: 
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....
 
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.
 
Back
Top