title: How to export CSV file encoded with "Unicode"
body: <p>Currently i using VBA code to export range data to a CSV file:</p>
  
  <pre><code>Sub Fct_Export_CSV_Migration()   Dim Value As String   Dim size As Integer
  
    Value = ThisWorkbook.Path &amp; "\Export_Migration" &amp; Sheets(1).range("B20").Value &amp; ".csv"   chemincsv = Value
  
    Worksheets("Correspondance Nv Arborescence").Select   Dim Plage As Object, oL As Object, oC As Object, Tmp As String, Sep$   Sep = ";"   size = Worksheets("Correspondance Nv Arborescence").range("B" &amp; Rows.Count).End(xlUp).Row   Set Plage = ActiveSheet.range("A1:B" &amp; size)
  
    Open chemincsv For Output As #1   For Each oL In Plage.Rows
      Tmp = ""
      For Each oC In oL.Cells
        Tmp = Tmp &amp; CStr(oC.Text) &amp; Sep
      Next
  
  
  'take one less than length of the string number of characters from left, that would eliminate the trailing semicolon
      Tmp = Left(Tmp, Len(Tmp) - 1)
  
      Print #1, Tmp   Next   Close
  
  
  
    MsgBox "OK! Export to " &amp; Value End Sub
  </code></pre>
  
  <p>Now, i would like to export CSV encoded with "<strong>Unicode</strong>". I think i need to use VBA function like SaveAs( xlUnicodeText ) but how to use that ?</p>
  
  <p>Thx</p>