title: Code does not save .csv file properly
body: <p>I have a excel workbook that i want to save as a csv file. 
  This is the code i use:</p>
  
  <pre><code>Application.DisplayAlerts = True
  
  ActiveWorkbook.SaveAs FileName:= _
  "C:\Users\Geoffrey\Dropbox\DCS PROGRAM\FILES\1. QUOTES\3. PROGRAM FILES\DOOR QT REQUESTS\DOORS_COMBINED.csv", FileFormat:=xlCSV _
  , CreateBackup:=False
  
  
  Workbooks.Open ("C:\Users\Geoffrey\Dropbox\DCS PROGRAM\FILES\1. QUOTES\3. PROGRAM FILES\DOOR QT REQUESTS\DOOR PROGRAM.xlsm")
  
  Workbooks("DOORS_COMBINED.csv").Close
  </code></pre>
  
  <p>The problem is when i save it it does not look the same as the excel workbook.</p>
  
  <p>Excel file:</p>
  
  <pre><code>  A        B      C       D
  Item 1  Item 2  Item3   Item 4
  Item 1  Item 2  Item3   Item 4
  Item 1  Item 2  Item3   Item 4
  </code></pre>
  
  <p>.CSV File: (Everything gets combined into column A)</p>
  
  <pre><code>          A                    B        C       D
  Item 1Item 2Item3Item 4
  Item 1Item 2Item3Item 4
  Item 1Item 2Item3Item 4
  </code></pre>
  
  <p>If i save this manually as a .csv it turns out correct.</p>
  
  <p>I think this could be the problem. I set excel to read the delimeter as ; because my descriptions contain commas. </p>
  
  <p><a href="https://i.stack.imgur.com/ZiZk6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZiZk6.png" alt="File opened in notebook"></a></p>
  
  <p><a href="https://i.stack.imgur.com/nvdWS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nvdWS.png" alt="enter image description here"></a></p>
  
  <p>Notepad view when using VBA to SaveAs:</p>
  
  <p>Notepad view when SaveAs manually:</p>