title: How to create an array or dictionary from reading excel
body: <p>My code below fails and doesn't allow me to create an array including cells from g5 to g5000. How would I create a dictionary if I wanted to latter compare that column of data to another column.</p>
  
  <pre><code>Dim xlApp, xlBook, xlSht 
  Dim filename, cellarray
  filename = "c:\users\a352592\desktop\finRate.xls"
  
  Set xlApp = CreateObject("Excel.Application")
  set xlBook = xlApp.WorkBooks.Open(filename)
  set xlSht = xlApp.activesheet
  
  cellarray = "xlsft.cells(5,7) to xlsft.cells(5000,7)"
  </code></pre>