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 can you close the second opened browser?

0 Answers  


How you create new action in qtp?

0 Answers  


There are 10 rows in the datatable. How can we fetch 2 rows and then skip 3rd row. After that, pick 4th & 5th row and skip 6th row. Please share code

0 Answers  


How to automate the windows dialog box which is coming in the run mode? Whenever I run my scripts,I am getting dialog box ( for ex: Pls enter zipcode" eventhough I already entered the value,the dialog box pops up).I need to click it. Pls give some idea-How to automate the dialog box which is pop up in the runtime.

2 Answers  


What are the drawbacks of QTP?

10 Answers   Ordain Solutions,






give me the code to save all messages of inbox of gmail into a folder and notepad

0 Answers   Infosys,


hi Action 1 and action2 if we save it in C:, what folders will be created explain plz

3 Answers   iFlex,


How i can use Regular expression in QTP?give detailed steps for it.

2 Answers  


synchronization, wait,wait Property?

1 Answers  


How can we use the "CreateObject("Shell.Application")" in QTP and what is the definition and purpose of it?

0 Answers  


pls tell me different type of automation frame works in QTP and which one need to select in client server application

7 Answers   Syntel,


In QTP, Which are the concepts are needed to do Functional testing and Regression testing?

3 Answers   IBM,


Categories