Hi,

I have data in the CSV file and in one column there is DATE values.
If i open the csv file in Excel, and the value in a cell i
"01/10/2006".

If i open the same .csv file through vba codin
Application.workbooks.open(...)

then the cell value shows as "10/01/2006".

Is there any way that i can get the original value "01/10/2006"

Thanks in advance

mtpsures

--
mtpsures
-----------------------------------------------------------------------
mtpsuresh's Profile: http://www.excelforum.com/member.php...fo&userid=3181
View this thread: http://www.excelforum.com/showthread.php?threadid=55821