> Excel.Range("A1").TexttoColumns
>
>
> The above line does split the row up into multiple columns. It appears to
> base it upon Spaces as a delimiter. I want to be able to change that to a
> comma or a tab.
>
> Any help you could give me would be great!
Here's the TextToColumns params from the VBA ObjectBrowser:
Sub TextToColumns([Destination], [DataType As XlTextParsingType =
xlDelimited], [TextQualifier As XlTextQualifier =
xlTextQualifierDoubleQuote], [ConsecutiveDelimiter], [Tab], [Semicolon],
[Comma], [Space], [Other], [OtherChar], [FieldInfo], [DecimalSeparator],
[ThousandsSeparator])
Member of Excel.Range
HTH,
-seanA
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|