You (or your macro) need to invoke the Import Wizard to get the proper format.

1. swtich on the Macro Recorder
2. Data Import External Data... Import Data and then use the Wizard
manually
3. stop the Macro Recorder

Examining/adapting the Recorder code should solve your problem.
--
Gary''s Student - gsnu200835


"DAustin" wrote:

Hi there,

I have a macro that opens a csv file with dates (and then copies them into
another file), and although the dates are in dd/mm/yyyy format (and so is my
system), they always get opened as mm/dd/yyyy. This only happens when I run
the macro, not when I do the same thing manually.

I've found a few odd workarounds, but am hoping someone can help me find
something to cater for this that will leave the dates in dd/mm/yyyy!

:-)