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 do function returns a value?How can we pass one function value to other function as input

3 Answers  

w is time parameter

1 Answers   Syntel,

How can we change(increase or decrease)the size of a array variable with out loosing the previous values

1 Answers   DST Global Solutions,

I have recorded a test using qtp to download a file in an application. Code: Browser("MFA Work Queue Manager").Page("MFA Work Queue Manager").Link("Rules Maintenance").Click Browser("MFA Work Queue Manager").Page("Rule Maintenance").WebEdit("txtSearch").Set "PmtType" Browser("MFA Work Queue Manager").Page("Rule Maintenance").WebButton("Search").Click Browser("MFA Work Queue Manager").Page("Rule Maintenance").WebButton("Export").Click Browser("MFA Work Queue Manager").Dialog("File Download").WinButton("Save").Click Browser("MFA Work Queue Manager").Page("Rule Maintenance").Sync Dialog("Save As").WinButton("Save").Click Dialog("Save As_2").WinButton("Yes").Click Problem: When running this test it gives an error at line no. 5 as Save button object is not identified by it's parent object. This code I ran 4 times after recording at it was working fine but 5th time onwords, it starts giving me the above problem. I used exist property option, Check Property option but none of this changes work at all. Kindly help...

1 Answers   Bank Of America,

Can any body explain me how to prepare QTP frame work with an example?? alexander.gdk@gmail.com

1 Answers  

what is batch testing?

1 Answers  

how open two urls in one browser? plz urgent

9 Answers   Satyam,

how to run the script If QTP tool not identify object in web page

2 Answers  

Some time when i wanna learn the object i face issue like i am not able learn the object in proper manner... eg:for text bo on web page it should learn as webedit but some times it reads as winobject:internetexpoler-server, because of this i have to uninstall the qtp and re-install it again when i do this it reads the object perfectly.....plz suggest the soln

0 Answers  

How can we upload pdf files in qtp?

1 Answers   TCS, Syntel,

In a shared Object Repository in QTP if some object is changed how can the other script which is using the same object can be known

6 Answers   iGate,

Hi, Can anyone help me in esimating time for an application using QTP tool.. What factors should be considered while calculating the estimation time for QTP... Thanks in advance... Prasad Gali

3 Answers