title: Coded UI driving test from multiple excel files
body: <p>Our strategy for using Coded UI to test our software is to create several Excel spreadsheets each with the testing steps for a particular test case.  There will be one Driver spreadsheet that has a worksheet that lists the test cases to be run.  The idea is to read the Driver spreadsheet and then go open the individual test case spreadsheets to run the test steps.  The test steps will list a button or field, the action to perform (click, edit) and the data value or other expected result which will be passed to helper functions in the UIMap or hand written map.</p>
  
  <p>In my Coded UI project I have only one test method and it has one spreadsheet data binding associated with it.  I can open that file and read it with no problems.  How do I close that spreadsheet file and go open a different one at run time?</p>
  
  <p>What other ways are there to do what I am trying to do?</p>