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


Please Help Members By Posting Answers For Below Questions

what is the difference between the modular framework and datadriven frame work

2010


What are the different types of functions available in qtp and explain ?

660


What is Distributed testing? How does UFT support it?

684


What are the benefits of quick test pro(qtp)?

647


What is post recovery scenario?

1748






How many lines of code in each script of QTP?

4115


Explain different type of event trigger option.

613


How do you capture tooltip using QTP?

716


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?

1483


Get the count of files of similar types from a folder.

1075


whenever U using QTP,Test Director, Why we using separate Bug tracking tool?

1686


How to use reporter.report event in qtp ?

650


What is the difference between local and shared object repository in qtp?

642


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); }

1857


Which scripting language used by quicktest professional (qtp)?

749