Csv date format problem

  • Thread starter Thread starter DAustin
  • Start date Start date
D

DAustin

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!

:-)
 
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.
 
As with many of these things, no idea about why the original problem occurs,
but your alternative is great so I won't bother worrying any more ... thanks
very much!
 
Back
Top