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
what is the difference between the modular framework and datadriven frame work
What are the different types of functions available in qtp and explain ?
What is Distributed testing? How does UFT support it?
What are the benefits of quick test pro(qtp)?
What is post recovery scenario?
How many lines of code in each script of QTP?
Explain different type of event trigger option.
How do you capture tooltip using QTP?
I want to configure the OR and library files to a particular QTP test during run time. Note: OR and Library files are located in Quality Center. Is it possible in QTP? Anybody having code?
Get the count of files of similar types from a folder.
whenever U using QTP,Test Director, Why we using separate Bug tracking tool?
How to use reporter.report event in qtp ?
What is the difference between local and shared object repository in qtp?
I AM TRYING PORT CODE FROM WINRUNNER TO QTP AND DON'T KNOW TO HOW TO CHECK THE ERRORS. IN WINRUNNER FUNCTION RETURNS EIGHER 0 OR -1 AGAINST WHICH RESULT CAN BE MADE PASS OR FAIL BUT IN QTP I DON'T SEE FUNCTIONS RETURNING ANY VALUE. APPRECIATE IF ANYONE COULD HELP ME CONVERTING FOLLWOING WINRUNNER CODE TO QTP. set_window("Customer Service"); rc = web_obj_get_text("Summary","#2","#4",ssn,""," ",1); if (rc != E_OK) { report_msg("[GetSubscriberSummary] Could Not get subscriber SSN; rc = "&rc); myRC = rc; } else { ssn = StripBlank(ssn); if (DEBUG) report_msg ("[GetSubscriberSummary] SSN: "&ssn); }
Which scripting language used by quicktest professional (qtp)?