Hi,All
How to change background color of a cell in excel using qtp
and that too with out using Excel Object.(I am importing
the excel sheet by using ImportSheet method)
Answer Posted / srinivasa reddy m
Set oExcel = Createobject("Excel.application")
oExcel.Visible = True
Set oWorkBook = oExcel.WorkBooks.Open("c:\Book1.xls")
Set oWorkSheet = oWorkBook.WorkSheets(1)
oWorkSheet.Cells(1,1).Interior.ColorIndex = 38
| Is This Answer Correct ? | 15 Yes | 6 No |
Post New Answer View All Answers
Suppose you are using shared objects repository in your test and you want to split your present action? At that time shared object repository is single or it’s also splits?
Where you are storing your script?
How the smart identification is used in real time?Please explain with an example
What are the views available in qtp?
Hello Everyone, Please provide me the practical example of business component concept of QTP.Like how to create business component,how to connect the quality center etc.... Thanks in advance, Gaytri
If an application name changes frequently i.e while recording it has the name, in this case, how do qtp handles?
How does QTP identify an object?
What are the different attributes used with regular expression?
Explain the types of object repository?
Hi All , How can we decicde for pariticular frame(DataDriven or Keword Driven)in Project? Thanks Balaji
Describe how Smart Identification is used
is there any addin for remedy user application
Explain the N-tire structure(process) for Funds Transfer ( means give N ways to funds Transfer in an Application)
How to handle dynamic objects in quicktest professional?
What is the standard timing delay for web based application in qtp?