ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories >> Software >> Testing >> Automation-Testing >> WinRunner
 
 
 
Question 
If the data is stored in Excel sheet(2nd and 3rd), how to 
access it for Data Driven test;
Ex: table = "c:\demo.xls"
   How to access 2nd or 3rd sheet  data id demo.xls flie.
 Question Submitted By :: Murali K
I also faced this Question!!     Rank Answer Posted By  
 
Answer
 
Dim excelObj,counter
counter=1
Set excelObj=createobject("Excel.application") 'Excel Object
Set wbObj=excelObj.workbooks.open("c:\demo.xls") 'work bood 
object
Set wbs=excelObj.activeworkbook.worksheets("sheet2") 'work 
sheet object
while  not  isempty(excelObj.cells(counter,1)) 
	x=excelObj.cells(counter,1).value
	msgbox(x)
	counter=counter+1
wend
 
0
Uday Kumar. A
 
View All Answers
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com