with out using import sheet came is it possible to get the
excel sheet ?

Answers were Sorted based on User's Feedback



with out using import sheet came is it possible to get the excel sheet ?..

Answer / sandeep

i think no

Is This Answer Correct ?    1 Yes 1 No

with out using import sheet came is it possible to get the excel sheet ?..

Answer / chaitu.c

Dim ExcelObj
Dim ExcelWB
Dim NewSheet

Set ExcelObj = CreateObject("Excel.Application")
Set ExcelWB = ExcelObj.Workbooks.Open ("D:\Documents and
Settings\Administrator.SEERVER\Desktop\Test.xls")
Set NewSheet = ExcelWB.Sheets("ranga")
NewSheet.Cells(1,1)= "CHAITU"
ExcelWB.Save
ExcelObj.Quit

Set NewSheet = Nothing
Set ExcelWB = Nothing

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More QTP Interview Questions

How to handle exception when data table is not available in local host system or path is not correct(explain statement with example)

1 Answers  


what is QTP batch testing tool?

2 Answers  


What are table and db checkpoints?

0 Answers  


how many types of actions r there? what r they? explain? pls give any one answer?

3 Answers   IBM,


hi i have 4 yrs exp in manual and automation testing using QTP i need sample resumes plz can u send this mail id pbre1980@gmail.com

0 Answers  


How do we analyze the checkpoint results?

0 Answers  


what is test scheduleling?

0 Answers   IBM,


Is it possible to change the name of a test object. I mean when we are recording the script for an object (for Ex: Username is a text field which has value "Babu",i am recording that). Then the Name of the object will become "Babu" in object repository. If i want to change "babu" as "xxxxx" .. is it possible to do? Pls help me in this .. if you didn't understand the question, pls let me know.

4 Answers  


how can u put synchronization point in qtp,wat is exactly synchroniztion why we use it wat is benifit in qtp

13 Answers   College School Exams Tests, Mind Tree,


how could i download qtp in which i get add-in support for 'oracle' is there any way to get it? i finding but not getting pls help me out :)

0 Answers  


What is quick test pro? What is a quick test professional?

0 Answers  


What is descriptive programming?

15 Answers   Wipro,


Categories