title: How to open and save XML UTF8 unix file in VBA Excel?
body: <p>I'm trying to do some changes in xml file which was created on unix system in Excel VBA.</p>
  
  <p>I'm using this code:</p>
  
  <pre><code>Sub TestXML2()
      Dim XDoc As Object    
      Set XDoc = CreateObject("MSXML2.DOMDocument")
      XDoc.Load ("C:\test\input.xml")
      XDoc.Save ("C:\test\output.xml")
      Set XDoc = Nothing
  End Sub
  </code></pre>
  
  <p>When i run this code, the code stops with error:
  x80004005 Character cannot be saved in ASCII coding (translated from other language).
  Part of the output file was saved but when i compare input and output files there are 2 differences:</p>
  
  <ol>
  <li>New file has "crlf" end of lines, input has "lf" only.</li>
  <li>In new file are  non ASCII chars converted to ASCII chars, ie: '&amp;#252'; is converted to u (should be ü).</li>
  </ol>