title: Load csv file into a VBA array rather than Excel Sheet
body: <p>I am currently able to enter csv file data into Excel VBA by uploading the data via the code below then handling the table, surely not the best way as I am only interested in some of the data and delete the sheet after using the data:</p>
  
  <pre><code>Sub CSV_Import() 
  Dim ws As Worksheet, strFile As String 
  
  Set ws = ActiveSheet 'set to current worksheet name 
  
  strFile = Application.GetOpenFilename("Text Files (*.csv),*.csv", ,"Please select text file...") 
  
  With ws.QueryTables.Add(Connection:="TEXT;" &amp; strFile, Destination:=ws.Range("A1")) 
       .TextFileParseType = xlDelimited 
       .TextFileCommaDelimiter = True 
       .Refresh 
  End With 
  End Sub 
  </code></pre>
  
  <p>Is it possible to simply load the csv into a two dimensional variant array in VBA rather than going through the use of an excel worksheet?</p>