Hi,All How to change background color of a cell in excel using qtp and that t

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)

Question Posted / linuskh

1 Answers
17167 Views
I also Faced
E-Mail Answers

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 write business scripts using object repository with different scenarios

0 Answers

What is diff betwee datatable.importsheet "path" and datatable.import

2 Answers

write a regular expression pattern for xyz?123?

1 Answers FAI,

How can I change object description or check point values in qtp?

0 Answers

hi guys we r working in office...we write some scripts..suddenly we have a work(5min only) in out side..what will do now,,,used to system shut down or log off or lock or sleep mode,switch use or hibernate?

0 Answers

Regular expressions..... Actually how to use this and what is the exact syntax and can anybody can help me out this with example.is there any docs pls send to my mailid rvreddy82@gmail.com

1 Answers UHG,

how i will connect oracle or microsoft acess database through manually written Script

2 Answers Aurigo,

I have 3 browsers i want to give facebook url in 2 nd browser using qtp

3 Answers Tech Mahindra,

How to add verification steps to tests?

1 Answers

what is Business Process Testing plz explain?

7 Answers iFlex,

In qtp what type of data tables are used , name and list out them

1 Answers Polaris,

How will you check a web application for broken links using qtp?

0 Answers

For more QTP Interview Questions Click Here