Using Workbook.OpenText will chage dateformat dd/mm/yyyy =
mm/dd/yyyy.

Workbooks.OpenText Filename:="C:\Test1.csv", DataType:=xlDelimited, _
TextQualifier:=xlTextQualifierNone, FieldInfo:=Array(1, 4)

This have been fixed in a hotfix for excel 2002
http://support.microsoft.com/default.aspx?kbid=835718

Is there any hotfix for excel 2000 or work around?

Thanks in advance

// Mats