title: Is there a way to open CSV with VBA and choose the delimiter?
body: <p>I have a CSV with data separated by a semicolon &quot;;&quot; and I would like to open it in Excel with VBA.
  In my case, this VBA code will be run by users from various locations so I would like to write a code that will not be sensitive to local settings and produce the same output everywhere.</p>
  <p>I have tried several codes but it doesn't work. I do not understand why after reading the documentation.</p>
  <ul>
  <li><code>Set wb = Workbooks.Open(str_Path, Format:=6, Delimiter:=&quot;;&quot;)</code></li>
  <li><code>Set wb = Workbooks.Open(str_Path, Format:=4)</code></li>
  <li><code>Workbooks.Open Filename:=str_Path, Format:=xlCSV, Delimiter:=&quot;;&quot;</code></li>
  <li><code>Workbooks.OpenText str_Path, Semicolon:=True, DataType:=xlDelimited</code></li>
  <li><code>Workbooks.OpenText str_Path, Local:=True</code></li>
  </ul>
  <p>With all of these instructions, the workbook is open but the data are not properly separated.</p>
  <p>For example, here is a result, it seems that it separate the row over &quot;,&quot; and not &quot;;&quot; because my number &quot;1,2&quot; has been splitted:</p>
  <p><a href="https://i.stack.imgur.com/icb22.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/icb22.png" alt="enter image description here" /></a></p>
  <p>Thanks a lot for any ideas ! :-)</p>
  <p>Have a great day,
  Max</p>