Importing text
 

Hi, I wonder if you can help?

When you import data from a text file to Excel you use a wizard that has
three screens. The first screen asks you if the file is delimited and
the second screen asks you for the delimiters. The default is Tabs but
the data I import most often uses Semicolons, so I have to go to the
second page and check the box for Semicolon.

Is there a way to set the default delimiter to Semicolon so I do not
have to go through that exercise all the time?
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

Importing text
 

Hi Paul

Is there a way to set the default delimiter to Semicolon so I do not
have to go through that exercise all the time?

As far as I know this is not possible

but you can use a macro if you want.
See this page
http://www.rondebruin.nl/txtcsv.htm

--

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


"Paul Hyett" wrote in message ...
Hi, I wonder if you can help?

When you import data from a text file to Excel you use a wizard that has
three screens. The first screen asks you if the file is delimited and
the second screen asks you for the delimiters. The default is Tabs but
the data I import most often uses Semicolons, so I have to go to the
second page and check the box for Semicolon.

Is there a way to set the default delimiter to Semicolon so I do not
have to go through that exercise all the time?
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

Importing text
 

Hi Ron-

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


--
Jim
"Ron de Bruin" wrote in message
...
| Hi Paul
|
| Is there a way to set the default delimiter to Semicolon so I do not
| have to go through that exercise all the time?
|
| As far as I know this is not possible
|
| but you can use a macro if you want.
| See this page
| http://www.rondebruin.nl/txtcsv.htm
|
| --
|
| Regards Ron de Bruin
| http://www.rondebruin.nl/tips.htm
|
|
| "Paul Hyett" wrote in message
...
| Hi, I wonder if you can help?
|
| When you import data from a text file to Excel you use a wizard that has
| three screens. The first screen asks you if the file is delimited and
| the second screen asks you for the delimiters. The default is Tabs but
| the data I import most often uses Semicolons, so I have to go to the
| second page and check the box for Semicolon.
|
| Is there a way to set the default delimiter to Semicolon so I do not
| have to go through that exercise all the time?
| --
| Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email
me)

Importing text
 

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

You are correct Jim

Thanks

--

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


"Jim Rech" wrote in message ...
Hi Ron-

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


--
Jim
"Ron de Bruin" wrote in message
...
| Hi Paul
|
| Is there a way to set the default delimiter to Semicolon so I do not
| have to go through that exercise all the time?
|
| As far as I know this is not possible
|
| but you can use a macro if you want.
| See this page
| http://www.rondebruin.nl/txtcsv.htm
|
| --
|
| Regards Ron de Bruin
| http://www.rondebruin.nl/tips.htm
|
|
| "Paul Hyett" wrote in message
...
| Hi, I wonder if you can help?
|
| When you import data from a text file to Excel you use a wizard that has
| three screens. The first screen asks you if the file is delimited and
| the second screen asks you for the delimiters. The default is Tabs but
| the data I import most often uses Semicolons, so I have to go to the
| second page and check the box for Semicolon.
|
| Is there a way to set the default delimiter to Semicolon so I do not
| have to go through that exercise all the time?
| --
| Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email
me)

Importing text
 

In microsoft.public.excel.misc on Tue, 10 Jul 2007, Jim Rech
wrote :
Hi Ron-

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


Thanks for this.

Regards,
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)