Change Default Delimiters

[Guest]

Hello,

How do I change the default delimiters in Excel 2007? I want to add ';' and
',' to the default delimiters instead of selecting it every time I import
files.

 

[Ron de Bruin]

You can do that in the code on my website
See reply in your other thread

 

[Guest]

I don't get it. I haven't programmed since C++ in college. Is there a way for
me to adjust the defaults in Excel so that it will be in effect for all
imports as well as new workbooks or do I have to use code?

 

[Ron de Bruin]

From a old thread with Jim Rech:
This is the only way as far as I know
******************************

This isn't a big help but I find that, if I do a Data, Text to Columns and
specify the semicolon, then any text file imports I do after that the
semicolon remains selected. Excel 2003 anyway.

So you could 'prime' the text import wizard for an Excel session with this
macro:

Sub PrimeTextImport()
Workbooks.Add
ActiveCell.Value = "abc"
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited,
_
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
Semicolon:=True
ActiveWorkbook.Close False
End Sub

 

[Guest]

Ok. I'll give coding a try. Thanks Again!

From a old thread with Jim Rech:
This is the only way as far as I know
******************************

This isn't a big help but I find that, if I do a Data, Text to Columns and
specify the semicolon, then any text file imports I do after that the
semicolon remains selected. Excel 2003 anyway.

So you could 'prime' the text import wizard for an Excel session with this
macro:

Sub PrimeTextImport()
Workbooks.Add
ActiveCell.Value = "abc"
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited,
_
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False,
Semicolon:=True
ActiveWorkbook.Close False
End Sub