Can any 1 modify the code whr in want to add\rename a excel
sheet in qtp?
- 1 Answers
- 3585 Views
- I also Faced
- E-Mail Answers
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 |
Mention what is the main difference between function and sub-procedure?
a;;b;c;;;d in this string output is abcd will come how can we do that in vbscript in QTP testing?
how to check whether link is disabled in QTP??
input values to accept 2 numbers & print the product, difference and sum using switch case
How do you get the value of a combo box in Javascript?
Difference between dim,public and private variables in vb script?
Can automation testing find ssame no. of bugs what we can find by manual testing?
Mention how you can call vbscript functions?
how to add action through AOM in QTP
Dear All, I am geting below IE error whilie executing the QTP scripts in Batch mode "Internet Explorer has encountered a problem and needs to close. We are sorry for the inconvenience." can any one suggest me how to resolve this issue . Thanks Balaji
how to declare a variable in vbscript using vbscript
about vb scripting programs this type of all question& answers
ASP 
