title: Load contents of CSV file to array without opening file
body: <p>I have a requirement to collate over 6000 csv files into a single csv document.  The current VBA process is:
  1. Open individual CSV data file
  2. Load contents of file to array based on number of rows
  3. Close individual CSV file
  4. Process array</p>
  
  <p>In order to improve efficiency of the code and processing, I was hoping there may be a method to load the data from the individual CSV files into an array without opening and closing every single file.</p>
  
  <p>I am using Excel 2011 for Mac.</p>