title: How to save a text file (CSV) with UTF-8 without BOM encoding in VBA (Excel)?
body: <p>So this was my initial question. <strong><em>The answer</em></strong> to my question below, seems to be that the only solution to get UTF-8 (and UTF-8 without BOM) encoding, is to use the ADODB.Stream object.<br> The answer to my new question in the subject line is posted as a code.<br>
  <br><em>I am sitting here and trying to <code>Save</code> an Excel sheet as a <code>.CSV</code>-file with a VBA macro.<br> 
  However, I am wondering if it matters whether I use <code>ADODB</code>/<code>ADODB.Stream</code> or just <code>.SaveAs</code> <code>Fileformat:=xlCSV</code>. I have tried to Google it, and it seems like I cannot find an answer to which method is the "best". I would need it to be comma delimited, UTF-8, and double quotations ("") as text-identifier.<br>
  <br>
  Is it correct that when you use <code>Fileformat:=</code>, it is not possible to <code>SaveAs</code> UTF-8, since the <code>xlCSV</code> is not using that encoding?</em> <strong>YES, that is correct.</strong><br></p>
  
  <p>See my answer for the solution.</p>