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...


Can any 1 modify the code whr in want to add\rename a excel
sheet in qtp?



Can any 1 modify the code whr in want to add\rename a excel sheet in qtp?..

Answer / senthkum

Option Explicit

Dim Excel, ExcelSheet, b, c, rc, a

Set Excel=createObject("Excel.Application")
Set ExcelSheet=createObject("Excel.sheet")
ExcelSheet.Application.visible=true


'''''storing the datas into excel sheet'''''''''''
a = "senthil"
b = "mercury"
c = "Pass"



Excel.ActiveSheet.cells(1,1).value="AgentName"
Excel.ActiveSheet.cells(1,2).value="Password"
Excel.ActiveSheet.cells(1,3).value="Result"

Excel.ActiveSheet.cells(2,1).value= a
Excel.ActiveSheet.cells(2,2).value= b
Excel.ActiveSheet.cells(2,3).value= c

ExcelSheet.SaveAs "C:\excelwrite.xls"

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More VB Script Interview Questions

How do you declare a variable in vbscript?

0 Answers  


find the length of the string without using length function?

4 Answers   CSS Corp,


how to store charecters of HARIBABU Using arrays

4 Answers   Cap Gemini,


what is descriptive programming in QTP and what is environment variable in QTP? where we store and what is its use?

4 Answers   Perot Systems,


give me any information abou vb script books learn quckly

0 Answers  


Write VB script to convert from feet to inches(hint 1feet=12 inches)

2 Answers  


write a vb script to add two 2*2 matrix

2 Answers  


Which operator can be used to change the value of the operand or change the state of the condition?

0 Answers  


HOW TO OPEN NEW TAB USING VB SCRIPT IN QTP?

1 Answers   TCS,


Explain the tristate constants in vbscript?

0 Answers  


Which in-built function related to an array joins substrings into one string in the vbscript language?

0 Answers  


Explain the extension .hta?

0 Answers  


Categories