Date format is not correct when using OpenText in Excel 2000

[Mats L]

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

 

[Dave Peterson]

A common workaround is to rename the text file to .TXT. Then you can specify
the type of date you want (dmy).

I like to record a macro when I do it manually to get the fields correct.