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
- 17055 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 can you write the scripts that operate on different objects depending on run-time information?
Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.
How to use parameterization in qtp?
how can i sent QTP results to the Html, notefile ,xl file give me the code using g mail login page
How does qtp recognize objects in aut?
When using descriptive programming?
How will you find the current time of the remote machine using QTP script?
What is quicktest professional window?
How many add-ins comes by default with quicktest professional (qtp)?
When Recovery scenario actually starts while testing the application?
what is review
Give me detailed theritical explanation about keyword driven, hybrid framework, environment variables, hybrid frame work
Plz Explain AUTOMATION REFERENCE MODEL?
What are the steps involved in recovery scenario wizard?
what type of values given to objects. EX::Set oBrowser=Description.Create oBrowser(“micclass”).Value=”Browser”
