title: Open csv file delimited by pipe character "|" or not common delimiter
body: <p>I'm trying to set up an Excel VBA code that opens up some .csv files and split into columns the information contained and delimited by the character <code>|</code>. I manage to open the file but the code I use opens my files without splitting the text according to the delimiter. So far I have tried the following code:</p>
  
  <pre><code>Sub OpenCSV()
  
  Dim wkbTemp As Workbook
  Dim sPath As String, sName As String
  
  sPath = ThisWorkbook.Path &amp; "\CSV_Files\"
  sName = "Test.csv"
  
  Set wkbTemp = Workbooks.Open(Filename:=sPath &amp; sName, Format:=6, Delimiter:="|")
  
  End Sub
  </code></pre>