Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel TextToColumns
Message
 
 
À
14/03/2002 07:36:14
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00632313
Message ID:
00632641
Vues:
12
>>>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.
>
>When setting column widths in Excel, I found I couldn't use a range like "A:A". Instead, I had to use specific cells, like "A1" (actually, I refer to cells by numbers (row, col). Here, the situation might be similar.
>
>HTH, Hilmar.

No I figured out that I need to parse as the first parameter an object reference to the range:
That works:
oRange.TextToColumns(oRange,1,1,.F.,.F.,.F.,.F.,.F.,.T.,":")
Christian Isberner
Software Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform