title: Excel VBA application.match returns error 13 (type mismatch) on a .csv file
body: <p>I have the following Excel VBA code:</p>
  
  <pre><code>Dim xlApp As Excel.Application
  Dim SearchRequest As Workbook
  Dim SecondCols As Variant
  Dim businessNameStartRow As Variant
  
  Set xlApp = New Excel.Application
  Set SearchRequest = xlApp.Workbooks.Open("test.csv")
  SecondCols = SearchRequest.Worksheets(1).Range("B1").EntireColumn
  businessNameStartRow = Application.Match("business_name", SecondCols, 0)
  </code></pre>
  
  <p>When I run it, Application.match returned error 13 (type mismatch), but when I saved the .csv file as an .xls file and run the same code against the .xls file, it was fine.</p>
  
  <p>Hope somebody can explain why and give a solution without changing the file.</p>