Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel TextToColumns
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00632313
Message ID:
00632636
Views:
11
>Hi, Christian!
>
>>>
>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 = ":"
><<
>
>Did you tried
>
>oRange.TextToColumn("A:A", , , , , , , , .T., ":", , , )
>
>
>or
>
>oRange.TextToColumn("A:A", , , , , , , , .T., ":")
>
>
>or
>
>oRange.TextToColumn("A:A", "", "", "", .F., .F., .F., .F., .T., ":" )
>
>
>or other combinations similar to these samples?

Yes, it give the following error:
"Unable to get the TextToColumns property of the Range class".

I can't figure out what's going on here.
Christian Isberner
Software Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform