title: Use comma instead of dot for decimals when saving as text
body: <p><em>This question looks similar to <a href="https://stackoverflow.com/questions/6215267/visual-basic-handle-decimal-comma">Visual basic handle decimal comma</a>, but that one is about an entirely different problem.</em></p>
  
  <p>I am writing a VBA macro to save my Excel file to a <code>.txt</code> file. This code line was generated by actually recording a macro where I saved the file to <code>.txt</code>:</p>
  
  <pre><code>ActiveWorkbook.SaveAs Filename, FileFormat:=xlText
  </code></pre>
  
  <p>Now, the issue is that the <code>.txt</code> file has all decimals formatted with dots, while I require them to be commas. For instance, it writes <code>32.7</code> while I am expecting <code>32,7</code>. </p>
  
  <p>Some interesting details:</p>
  
  <ul>
  <li>I have made sure that Windows and Excel are setup to use the correct local settings. Everywhere I look, decimals are displayed correctly with commas.</li>
  <li>When manually saving the workbook, it correctly writes commas to the file as well. However, when executing the VBA code I recorded when doing this, I get dots.</li>
  </ul>
  
  <p>Is there some nifty argument or option that I forgot? I am truly at a loss here -- even my fourth cup of coffee is not bringing any inspiration.</p>