title: Import semicolon separated CSV file using VBA without rename to txt
body: <p><strong>This is not a duplicate since I want a solution not constisting in reformatting file to txt:</strong></p>
  
  <p>my intention is to open a csv file using semicolon as delimiter. For that purpose I have used the following code:</p>
  
  <pre><code>Sub prueba2()
  
  
  Dim sfile As String
  Dim wb As Workbook
  Dim Path As String
  Dim Namefile As String
  
  
  Path = "V:\evfilesce9i9\apps9\vbe9\dep4\KFTP\KFTP001D_FicherosCeca"
  Namefile = "\QryCECARFSECTORIAL0239*.txt"
  
  
  Set wb = Workbooks.Open(Filename:=Path &amp; Namefile, Delimiter:=";")
  
  End Sub
  </code></pre>
  
  <p>When I try it, it is opened using commas as delimiter instead of which I have specified (semicolon)</p>
  
  <p>I have read in other questions that this is normal in post 2006 Excel versions, and that the fastest solution is to reformat file to a txt. </p>
  
  <p>This does not fit into my needs because I have to do it without changing format. I don't find any solution. </p>
  
  <p>Could someone help me?</p>