title: Reading all rows of a specific column in excel with VB Script
body: <p>I have a spreadsheet that has all of our customer information. So we have Customer 1,2,3,4,5 and each customer has an EMAIL_ADDRESS column with one or more email addresses. I need to read all of those addresses and output them in some form or fashion. We have column <code>AJ</code> labeled <code>Email_Addresses</code> and I need to pull all of the emails for every Customer or Row.</p>
  
  <p>I found this code </p>
  
  <pre><code>Dim xlApp 
  Dim xlBook 
  Dim xlSheet 
  Set xlApp = CreateObject("Excel.Application") 
  xlApp.visible = true 
  Set xlBook = xlApp.Workbooks.open("D:\Macro\BirthDay.xls") 
  Set xlSheet = xlBook.Worksheets("Sheet1") 
  MsgBox  xlSheet.Cells(1, A1).Value
  </code></pre>
  
  <p>However my question is how do I get this or some code to read ALL ROWS in Email_Address Column <code>AJ</code>.</p>