Decimal separator
Perhaps Chip Pearson's code:
http://www.cpearson.com/excel/imptext.htm import/export text files Allows you to specify the list separator. Not sure it, as written, supports a different decimal separator. -- Regards, Tom Ogilvy "Jan Karel Pieterse" wrote in message ... Hi, Excel XP was the first version that has these properties. You simply cannot use them with earlier versions and you need to use a workaround to do what you want. I suspect you want to import delimited data with a particular decimal separator. In Excel 2000 and below, you have to change the regional settings to be able to do that OR use code that parses the text file itself. I've seen code somewhere that does that, but couldn;t find it. Regards, Jan Karel Pieterse Excel TA/MVP -----Original Message----- Hi, I have an application made in XP which crashes when running on 2000. The 2000 version does not tolerate With Application OldDecimalSeparator = .DecimalSeparator OldUseSystemSeparators = .UseSystemSeparators .UseSystemSeparators = False .DecimalSeparator = "." End With How can I do this so it is version independent between XP and 2000? Any help appreciated. jacob . |
All times are GMT +1. The time now is 06:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com