title: Excel into CSV VBA
body: <p>I am having trouble saving one sheet from my workbook into a CSV file. I have 18 sheets in the one workbook. Every time I run the macro, it saves a different sheet. I also need it so the display alerts do not pop up. I am a beginner to VBA and running macros, so any help would be appreciated.</p>
  
  <pre><code>   Sub csvfile()
   '
   ' csvfile Macro
   '
  
   '
  
     ChDir "C:\Users\RM\Documents"
     ActiveWorkbook.SaveAs Filename:= _
      "C:\Users\RM\Documents\Working_Program\PSSE_Export_Data.csv", FileFormat:= _
      xlCSV, CreateBackup:=False
      Application.DisplayAlerts = False
  
  
  
  
  
  End Sub
  </code></pre>