title: Excel sheet doubts in vbscripting
body: <p>I am creating an excel file as shown below
               strFileName = "c:\test.xls"</p>
  
  <pre><code>         Set objExcel = CreateObject("Excel.Application")
           objExcel.Visible = True
  
           Set objWorkbook = objExcel.Workbooks.Add()
           objWorkbook.SaveAs(strFileName)
  
           objExcel.Quit
  </code></pre>
  
  <p>Now after some data manipulation i populate some values into the excel sheet manually in sheet1 and sheet2 of the same excel sheet.
  I would be glad if anyone could tel me how to compare two values in two different sheets of the same excelk sheet
  For eg:
  sheet1 has</p>
  
  <pre><code>             **Executables**             **checkbox**
                  E1                             yes
                  E2                             No
                  E3                             yes
  </code></pre>
  
  <p>and sheet2 has
                    Executables        Number of parameters   input1  Input 2
                       E1<br>
                       Send               2                      4     {ENTER}
                       Put                2                    Input.xls   {ENTER}
                       Send               2                       4        {ENTER}                                                            {ENTER}
                      <br>
      Now i want my vbscript shud search in sheet 1 for each yes and then come here and search in sheet2.How would i do a  comparitive search on sheet1 and sheet2 in the same excel sheet files</p>
  
  <pre><code>        Thanks
          Maddy   
  </code></pre>