Hi,

Using Excel 2007

I have a csv file that when opened manually has the correct date
format of DD/MM/YYYY

When I open the file with VBA, the date format defaults to MM/DD/YYYY,
some of the dates come through as text fields.

Even importing this through VBA as a text file (with .csv extension)
and changing the format to D/M/Y it still comes in as MM/DD/YYYY and
some of the fields being text, when I change the extension to ".txt"
it imports OK

I do not want to have my code renaming the files to .txt in order to
get the correct date format

Any help on this would be greatly appreciated

Regards
Raymond Allan