Ric,

In int'l environments you'll need to avoid the CSV driver like the plague
CSV is a pesky and VERY badly written converter.

When you rename the .csv file to .txt, and THEN open it you have far more
control.


If you program for Excel XP+ only have a look at the workbooks.OpenTEXT
method.

You can also force a standard text open and then use the TextToColumn
wizard dialog.

I'm no longer a frequent visitor to the ng, pls email if questions
adres below


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Ric" wrote:

This is driving us crazy. It appears that when we use OLE
to open a csv in Excel, all dates are being interpreted as
US format, despite the regional settings being set to UK.
If we open the csv manually then all is fine. Someone has
suggested that this is a bug and the solution is to go
back to using DDE, but I cannot find any information about
it. Can somebody please confirm one way or the other and
maybe offer a solution ? We are using VB6.