list separator
To all,
A question of understanding: We have an application that generates .csv files, the delimiter is determined by the locale of the user by reading their regional settings - list separator. When Excel opens a csv file using open-with Microsoft Excel does it read the required list separator from anywhere other than the users regional settings list separator? Because it works in the UK but not in Spain! Your thoughts would be appreciated Cheers Kieran |
list separator
Kieran,
You can get the user's setting with: ?Application.International (xlListSeparator) Also available, xlThousandsSeparator etc. Depending what you are doing, you can use .OpenText and specify the delimter(s) used. But without code, Excel just defaults to the user's setting as shown in the Control Panel, whatever the actual file contains. NickHK "Kieran H" wrote in message oups.com... To all, A question of understanding: We have an application that generates .csv files, the delimiter is determined by the locale of the user by reading their regional settings - list separator. When Excel opens a csv file using open-with Microsoft Excel does it read the required list separator from anywhere other than the users regional settings list separator? Because it works in the UK but not in Spain! Your thoughts would be appreciated Cheers Kieran |
All times are GMT +1. The time now is 10:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com