title: Remove last character in csv file, Excel vba
body: <p>I am generating a CSV file from Excel (2013) like this:</p>
  
  <pre><code>.SaveAs Filename:= _
      filePath &amp; MyFileName, _
      FileFormat:=xlCSV, _
      Local:=True, _
  </code></pre>
  
  <p>That works fine but at the last row I get semicolon in the end as well:</p>
  
  <pre><code>994085;None ApS.;2;G; 12 ;31-12-2015; 40 ; -   ;Operational TB ;
  </code></pre>
  
  <p>How can I remove the last ; in that file?</p>
  
  <p>I saw it is easy in a string. I am not sure I can put the whole file into string. It is around 6-700K characters. It has to go pretty fast no matter what I implement</p>
  
  <p>Any ideas appreciated!</p>