How use TextToColumns in Win32com

Question

I would like a exemple how to use TextToColumns in Win32com

Sub VBA_Code()
  Columns("A").TextToColumns DataType:=xlDelimited, FieldInfo:=Array(1, xlDMYFormat)
End Sub

score 1 · Accepted Answer · answered Jun 01 '20 at 11:50

1

I solved my own question using code below

xw.Range('A:A').api.TextToColumns()

Thanks

answered Jun 01 '20 at 11:50

marreco

1 Answers1