Hello,

Nowhere I can figure out how to use the TextToColumns method in Excel.
The problem is the parameter list:

oRange.TextToColumn(Destination, DataType, TextQualifier, ConsecutiveDelimiter, Tab, Semicolon, Comma, Space, Other, OtherChar, FieldInfo, DecimalSeparator, ThousandsSeparator)

I need to specify the follwowing parameters:
Destination ("A:A")
Other = .T.
OtherChar = ":"

How do I do that?