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 |
How do you declare a variable in vbscript?
find the length of the string without using length function?
how to store charecters of HARIBABU Using arrays
what is descriptive programming in QTP and what is environment variable in QTP? where we store and what is its use?
give me any information abou vb script books learn quckly
Write VB script to convert from feet to inches(hint 1feet=12 inches)
write a vb script to add two 2*2 matrix
Which operator can be used to change the value of the operand or change the state of the condition?
HOW TO OPEN NEW TAB USING VB SCRIPT IN QTP?
Explain the tristate constants in vbscript?
Which in-built function related to an array joins substrings into one string in the vbscript language?
Explain the extension .hta?