title: Opening ADO connection to Excel Spreadsheet in VBA
body: <p>How would I go about opening an ADO connection to an Excel 2007 spreadsheet?</p>
  
  <p>I am doing this in order to import the data into Access 2007. Rather annoyingly, the data needs to be fltered and pre-processed before being imported, hence why I want to open an ADO connection to read it.</p>