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)



Hi,All How to change background color of a cell in excel using qtp and that too with out using Ex..

Answer / 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

More QTP Interview Questions

How to Test Dynamic links ?

4 Answers   Wipro,


any one can send me the concepts of qtp

0 Answers  


How do you configure QTP AND Test director?

0 Answers  


How open an excel sheet in QTP(not a run time )?

4 Answers   Tech Mahindra,


How to get line numbers in your editor in expert view?

1 Answers  


How to record application running on the Virtual machine?

0 Answers  


hi. I Am working in Small IT company as Test Engineer. But am looking for change. I have 2+yrs experience, but my problem is MCA 72%, remaining all are Second Division. plz give solution for my problem.am elgible for MNC's or not. if not plz give suggestion............ already i forwarded my resume to lot of MNC's but. I didn,t get CAL............ plz give any suggestion.

3 Answers  


what is the abbrivation of .mtr in action reposirtory?

8 Answers   GE,


I am in need of some set of QTP FAQ @ interview. Also recently in one of interview portal they asked me how you write the script for Login application which it is web -based and using Descriptive Programming? Without associating the shared object repository?Please i do need this answer very soon? Please respond me soon @ vaisu72@yahoo.com

2 Answers  


Hi All, I Want To excute scripts batch without using QC .I need code for that Thanks Balaji

0 Answers  


How to execute a winrunner script in quicktest professional?

0 Answers  


Explain the features and benefits of quick test pro(qtp)?

0 Answers  


Categories