title: Convert a semicolon delimited csv to xlsx format from command line
body: <p>I want to generate an Excel file from a CSV file which I pass as an argument to VBScript. I adapted a script to get this code:</p>
  
  <pre><code>Dim file, WB
  Set xl = CreateObject("Excel.Application")
  
      For Each file In WScript.Arguments
          Set WB = xl.Workbooks.Open(file,0,True,6, ,,,,";")
          WB.SaveAs Replace(LCase(WB.FullName), ".csv", ".xlsx"), 51
          WB.Close False
      Next
  </code></pre>
  
  <p>I used the parameters <code>Workbooks.Open(file, 0, True, 4)</code> after reading the <a href="https://msdn.microsoft.com/en-us/library/office/ff194819.aspx" rel="nofollow noreferrer">MSDN documentation</a>. <code>4</code>is for "semicolon delimited text".</p>
  
  <p>The script generates the .xlsx file but doesn't consider semicolon as a delimiter but comma instead.</p>
  
  <p><strong>Sample input :</strong></p>
  
  <pre><code>Ticket N°;CustLName;Destination;Stopover;StartTime
  TVA5854656;Coleman;Fredericton;Montreal;20170110 08:25:00
  TVA5854695;Nixon;Brandon;Montreal,Fredericton,Moncton;20170110 08:25:00
  TVA5854752;Simard;Halifax;Montreal,Fredericton;20170111 08:25:00
  </code></pre>
  
  <p><strong>Sample Output:</strong></p>
  
  <pre><code>Ticket N°;CustLName;Destination;Stopover;StartTime      
  TVA5854656;Coleman;Fredericton;Montreal;20170110 08:25:00       
  TVA5854695;Nixon;Brandon;Montreal   Fredericton Moncton;20170110 08:25:00
  TVA5854752;Simard;Halifax;Montreal  Fredericton;20170111 08:25:00   
  </code></pre>