Under 'Customise Regional Options' is the short date format actually set to
dd/MM/yyyy ?
Peter Bircher

"SW" wrote in message
...
Hi,

I am using a macro to open a csv file, make some changes then save it.
I'm using

ActiveWorkbook.SaveAs FileFormat:=xlCSVWindows
ActiveWorkbook.Close SaveChanges:=True

to save the file.

The problem is, some of the data (which I'm not changing) is dates, eg
15/02/2005
this appears in the saved file as 2/15/2005.
I've checked my International settings and they're all UK so I don't know
what's wrong.
I've tried different file formats.
I just want the date to remain unchanged.

Thanks in advance for your help.

Regards
SW