When i open an .csv workbook manually by double clicking on it the data
in cell A2 = "2/07/2007"

but when i open the same workbook using below code

Workbooks.Open Filename:="...\a.csv", updatelinks:=No, ReadOnly:=Yes

the data changes to "7/02/2007"

Note : the data in cell A2 in .csv is date and format = *14/03/2001

I donno why this is happening? Does anybody know.