Interested to Buy Any Domain ? << Click Here >> for more details...
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)
- 1 Answers
- 17229 Views
- I also Faced
- E-Mail Answers
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
How you can delete excel file in qtp?
How do you do batch testing in wr and is it possible to do in qtp, if so explain?
banking project description for software tester
Is any limitation to xml checkpoints?
How can you identify the browser and its information using the qtp script?
How many add-ins comes by default with quicktest professional (qtp)?
How to handle Java tree in QTP?
Is it possible to split an action? How?
Explain the concept of object repository and how qtp recognises objects?
I would like to directly import XL file and work on that XL file directly in QTp script in that XL sheet need to allocate workbench,XL sheet and generate two bar graphs automatically how to do that? plz let me know any answers?
hou can we use vb script in qtp could u tell me breafly
How will you test a stapler?
Have you used xml check point in your project? How?
If I give some thousand tests to execute in two days what do you do?
any body can you help me what is the script to automate an comand promt
