Change Default Delimiters
 

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.

Change Default Delimiters
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Renee B." wrote in message ...
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.

Change Default Delimiters
 

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" wrote:

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Renee B." wrote in message ...
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.

Change Default Delimiters
 

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




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Renee B." wrote in message ...
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" wrote:

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Renee B." wrote in message ...
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.

Change Default Delimiters
 

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

"Ron de Bruin" wrote:

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




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Renee B." wrote in message ...
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" wrote:

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Renee B." wrote in message ...
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.