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
.