title: Opening CSV in Excel using VBA causes data to appear in two columns instead of one
body: <p>I created VBA code in Excel 2007/2010 to import data from a CSV file. Unfortunately, when I open the file programmatically, the data is split into two columns (A and B) for certain rows of data.</p>
  
  <p>When I open the CSV File manually, everything displays fine!</p>
  
  <p>Generally the CSV data looks like this (example header row):</p>
  
  <blockquote>
    <p>TBWAKT;"TBWAKO";"TBSAIS";"TBSKU9   ";"TBSMOD";"TBLETT";"TBKBNR
    ";"TBBEZ2                        ";"TBFAR2<br>
    ";"TBSUGC";"TBSOGC";"TBEINK                        ";"TBKBGR ";"TBKBGF
    ";"TBVKPE   ";"TBVKPR   ";"TBEKPE<br>
    ";"TBAUAN";"TBFAAN";"TBREAN";"TBSTAN";"TBRUAN";"TBKPAG";"TBERDT 
    ";"TBDATV  ";"TBDATB  "</p>
  </blockquote>
  
  <p>The data that causes problems includes a comma in the text. Here is an example:</p>
  
  <blockquote>
    <p>JEAN 5 POCHES EXTENSIBLE+1,60M</p>
  </blockquote>
  
  <p>Here is the code:</p>
  
  <pre><code>Private Sub OpenCSV(x As Integer, wkbDashboard As String, wkbCsvImport As String, wksDestination As Worksheet)
  ' Opens CSV and copies data to current workbook
  Dim wkbCsvImportName As String
  Dim r As Range
  
  Workbooks(wkbDashboard).Activate
  
  ' Open and read CSV
  Workbooks.Open Filename:=wkbCsvImport, Format:=xlDelimited, Delimiter:=";"
  wkbCsvImportName = ActiveWorkbook.Name
  </code></pre>
  
  <p>Screenshot of the problem. The stuff in red is in column B after opening the file.<br>
  <img src="https://i.stack.imgur.com/fzSyb.png" alt="enter image description here"></p>