Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change column Delimiter programmatically
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change column Delimiter programmatically
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 : 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert file from column to columns using delimiter | Excel Discussion (Misc queries) | |||
Parse delimiter is change from text to numbers | Excel Discussion (Misc queries) | |||
How can I programmatically change Link references? | Links and Linking in Excel | |||
How do I change the DEFAULT delimiter for pasting text data? | Excel Discussion (Misc queries) | |||
Change cell format programmatically | Excel Programming |