Change column Delimiter programmatically

  • Thread starter Thread starter Christian Nein
  • Start date Start date
C

Christian Nein

Hi,

I would like to know in which property Excel stores the column delimiter?
The default setting is tabulator but once the "Convert Text to Columns
Wizard" (Menu "Data/Text to Columns...") has been run with selecting another
delimiter, this setting is stored in this Excel instance and I don't know
how to reset it programmatically.

Regards
Christian
 
Define ALL parameters in your call.

If you just want to "reset" for the user
make a 'dummy' call on an empty cell.
you need to give it a value first else the method will fail

Sub ResetTTC()
With ActiveSheet.UsedRange.Resize(1). _
Offset(ActiveSheet.UsedRange.Rows.Count)
.Value = "x"
.TextToColumns _
Tab:=True, Semicolon:=False, Comma:=False, Space:=False, _
Other:=False, OtherChar:=vbNullString, _
Destination:=.Cells(1)
.Clear
End With
End Sub



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Christian Nein wrote :
 
Back
Top