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 to retrieve native property value in runtime?
In our application qtp unable to indentify the menu items,we tried number of times to add objetcs into object repository but fail. through normal recording mode only objects going to add into repository but while running same recording script qtp showing a error like " unable to indentify the object". in repository there is no any properties and pro values for that object and also i tried with virtual object config also unable to find the object in application and in repository. Then what i have to do to identify menu objects????? can anybody hell me pls..............
What are the advantages of vbscript?
Explain the arrays in vb script?
How to map test cases with Automation script? Please explain in details.With example Thanks for your co-operation(In Advance)
How strcomp function works?
while using Keyward driven framework in QTPif new requirements are added how to manage it...plz ans
how to add the shared repository file to the script file while running the script manuall
where can i learn VB scripint ?
write a qtp script to count the number of minimized windows
Which operator can be used to check if two numbers are equal or not in vbscript?
What are the differences between sub procedures and function procedures?