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.