CSV file format and Excel are notorious
if your regional settings are anything but USenglish :(
Step 1 .. RENAME the thing to TXT.
DO you have Excel XP or 2003?
Check out the LOCAL argument in
OpenText and
SaveAS methods
(again: ONLY for excel XP / 2003)
it appears to have been added as an afterthought..
and is hardly documented in VBA help.
keepITcool
< email : keepitcool chello nl (with @ and .)
< homepage:
http://members.chello.nl/keepitcool
"?B?UGF1bA==?=" wrote:
Hi,
I have a CSV file and one of the columns is date in the format of
DD/MM/YYYY. If I open this manually the date column is fine. If
however I open the same file in code...
Workbooks.Open Filename:="Log.csv"
Excel converts the dates where the first number is less than 13 to an
american type date. I.e. 03/10/2004 becomes 10/03/2004.
How can I stop this from happening???
Ta
Paul