Kieran,
I can't reproduce this with my English W2K/Office XP.
Excel follow the delimiter specified as the List Separator in the Regional
Options for opening .csv files.

NickHK

"Kieran H" wrote in message
oups.com...
I have the following problem:

London based PC

A comma delimited file will open correctly if opened with "Open With
Microsoft Excel for Windows" (csv extension)

Note the list separator within regional settings for UK specifies a
comma

Madrid PC

On a Spanish PC the same file with a semicolon delimiter fails to
open correctly even though the regional setting list separator
specifies a semicolon.

No code is running that might re-set the delimiter
Not loading correctly means the delimiter is being ignored.
I know that users could solve this by using the import text wizard but
I would really like to understand why the list separator in regional
settings is being ignored

Many Thanks

Kieran