vba: clipboard paste changes date to US format
<p>I'm pretty sure that somewhere, someone already managed to explain this problem, but I just cant find the right answer for me.</p>

<p>Here is the situation:
Out of a program I copy a list to the clipboard of windows with values like this</p>

<blockquote>
  <p>Something Date      Time      Something  Something ...</p>
  
  <p>Bla       31/03/16  02:20:22  Bla        Bla</p>
  
  <p>Bla       01/04/16  03:10:10  Bla        Bla</p>
</blockquote>

<p>Then the VBA code finds the last free Row and does</p>

<pre><code>.PasteSpecial xlPasteAll
</code></pre>

<p>The Result in Excel is</p>

<blockquote>
  <p>Bla 31/03/2016 20:22,0 Bla Bla</p>
  
  <p>Bla 04.01.2016 10:10,0 Bla Bla</p>
</blockquote>

<p>And that's not what it should be.</p>

<p>I tried <code>.PasteSpecial Format:="Unicode-Text"</code> with the same result</p>

<p>I cant get <code>Paste:=xlValues</code> and so on to work. (1004)</p>

<p>The best part is, if I right click (or ctrl+v) the sheet and past it, EVERYTHING just magically appears the right way.</p>

<blockquote>
  <p>Bla 31.03.2016 02:20:22 Bla Bla</p>
  
  <p>Bla 01.04.2016 03:10:10 Bla Bla</p>
</blockquote>

<p>So I assume I'm doing something very stupid and I just need to find the vba expression to make it right.</p>

<p>Can someone please help me.</p>