title: Save as CSV with semicolon separator
body: <p>I'm currently use this function for saving, but I have a problem with it:</p>
  
  <pre><code>Private Sub spara()
      ActiveWorkbook.SaveAs Filename:="T:\filepath+ ActiveWorkbook.Name", _
      FileFormat:=xlCSV, CreateBackup:=False
  End Sub
  </code></pre>
  
  <p>It automatically saves with <code>,</code> but I need it to save with <code>;</code> in its file. Is it possible to change how it saves somehow?  </p>
  
  <p>I've tried googling around for this issue, but all macros regarding .csv file saving are just how to save in .csv and how to split multiple sheets to .csv .</p>