Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading the separator from the regional settings in Excel 2002
I know there is a problem in excel 2002, that with saving as a CSV excel uses
always the US-Setting as regional settings (not using your choice for the seperator). If I open a *.csv with excel 2002 it uses the regional settings for the separator. So you have only one chance (microsoft workaround): Change your separator to the US-style (","). In my VBA application I want to check this with the following code: list_sep = Application.International(xlListSeparator) to ask for the separator. But with an english WindowsXP with an english XL2002 I always receive an ";" also with an "," as separator in the regional settings. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel not using regional settings | Excel Discussion (Misc queries) | |||
Regional Settings / Finding out Array separator characters | New Users to Excel | |||
Regional settings independent list separator in arrays | Excel Worksheet Functions | |||
TAB as list separator via regional setting | Excel Discussion (Misc queries) | |||
Excel ignores boot-time regional settings when interpreting a date | Excel Discussion (Misc queries) |