Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

What environment does qtp run in?

0 Answers  


Please help me by providing the License key for QTP 9.2, at guru_aarya@yahoo.co.in Best Regards Gururaj.B

0 Answers  


Explain roles and responsibilites of 2yrs Automation qtp engineer.

3 Answers   Oracle,


when will you do debug your script? and explain that process?

0 Answers   Covansys,


Hi,can anyone tell me How to found the number of 1's and 2's in the given format 1,1,2,2,3,3,4,2 using vbscript Thanks in advance

3 Answers  


What is log file?How to write log file code?

2 Answers   Apps Lab, Value Labs,


how to invoke the web application through script in qtp

8 Answers   Synechron,


Is it possible to change the name of a test object. I mean when we are recording the script for an object (for Ex: Username is a text field which has value "Babu",i am recording that). Then the Name of the object will become "Babu" in object repository. If i want to change "babu" as "xxxxx" .. is it possible to do? Pls help me in this .. if you didn't understand the question, pls let me know.

4 Answers  


what is localisation testing and globalisation testing? what is the difference between them?

1 Answers   CDC Software,


How to Test the mainframe application?

0 Answers   Unisys,


3 differences between QTP & Winrunner?

1 Answers  


How to find the difference between 2 dates in qtp?

0 Answers  


Categories