with out using import sheet came is it possible to get the
excel sheet ?
Answers were Sorted based on User's Feedback
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 |
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 - - - - - - - - - - - - - - - -
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?
Tell me the QTP Advantages and Disadvatages ?
Which object model ur used in ur project
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.
Explain step generator in qtp?
What is a Run Time Data table?
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?
How you automate testscripts one by one or modukewise or all at once
What is the standard timing delay for web based application in qtp?
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