What a bunch of cry babies! Grow up!
I was merely prompting Dennis to look at Excel's built-in functionality.
A single VBA statement can be created by simply by using the macro recorder...
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), DecimalSeparator:=",", ThousandsSeparator:="."
This message was edited by Mark W. on 2002-11-14 09:51