Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
delimiters and manipulation | Excel Worksheet Functions | |||
Missing delimiters after 15 records | Excel Discussion (Misc queries) | |||
using multiple delimiters at the same time | Excel Discussion (Misc queries) | |||
delimiting w/multiple delimiters? | Excel Discussion (Misc queries) | |||
How do I get carriage returns to not be row delimiters in text fi. | Excel Discussion (Misc queries) |