title: Excel Macro date format changing on file open
body: <p>I have a weird problem, whenever I open my csv file into excel manually, the dates appear correctly formatted in UK locale - dd/mm/yyyy. However, I have a macro which opens up my csv file, and I get some dates formatted in as mm/dd/yyyy and others formatted as dd/mm/yyyy. The pattern seems to be the ones which are incorrect seems to be when the is a single digit for the day so 05/11/2012 is now appearing as 11/05/2012, but 15/11/2012 is appearing exactly as the csv file.</p>
  
  <p>Any help would be great.</p>
  
  <p>Thanks
  Jalz</p>
  
  <pre><code>Sub openfile()
  '
  ' openfile Macro
  '
  
     Workbooks.Open filename:= _
      "c:\myfile.csv"
     Range("A1:J46").Select
     Selection.Copy
  End Sub
  </code></pre>