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

HI, Based On The Information Below Write A Data Driven test Script Edit Box 1 Should take Value From Num1 Column Edit Box 2 Should take Value From Num2 Column Click On Add Button, Get The Value Of Exp res Column, Get Value From Actual Result Edit Box , Compare Two Values, Write Pass / Fail Value Into Result Column Thanks In Advance... Kavitha Input.Xls Num1 Num2 Exp res Act res Result 10 30 40 40 Pass 50 40 90 90.5 - - - - - - - - - - - - - - - -

5 Answers   UHG,


We have 10 rows of records in data table, but we have to run 4th, 5th and 6th rows only. How can we handle this scenario in QTP?

5 Answers   Accenture, Banca Sella, Polaris,


why we are using environment variables instead of global variables?

1 Answers   TCS,


Tell me the QTP Advantages and Disadvatages ?

6 Answers   Accenture, CTS, GE,


Which object model ur used in ur project

2 Answers   Cap Gemini,






Hi! Using Descriptive Programming How do we get Parent object for an object by writing script(DP). Say, i want to get a parent object for a "Link" in a web page by writing script in Descriptive Programming.

0 Answers  


Explain step generator in qtp?

0 Answers  


What is a Run Time Data table?

1 Answers  


I have 5 no.of Action in my Test. Out off which i should make 3rd action as my start-up action. How should i make it?

5 Answers  


How you automate testscripts one by one or modukewise or all at once

1 Answers   Diebold,


What is the standard timing delay for web based application in qtp?

0 Answers  


if we can find the status of script in qtp that either it's pass or fail then why we need to put this status on different excel file or log file in hybrid framework .please let me know asap thanks

1 Answers   iCreate,


Categories