title: Remove commas from end of line in text file with VBA
body: <p>I have written a VBA code to output comma seperated data elements to a text file that will then be imported into a seperated application.  However, I am stuck how to remove the end of line commas generated in the text file.<br>
  The following is an example of my data:  </p>
  
  <pre><code>Scenario,Capital,AFE
  Capital Array,Drilling Capex 80/20,Replace,
  0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
  
  Capital Array,Facilities Tangible,Replace,
  0,0,0,0,0,0,0,0,0,0,0,0,0,0,250,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
  
  Capital Array,Recompletion 80/20,Replace,
  0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
  </code></pre>