Can any 1 modify the code whr in want to add\rename a excel
sheet in qtp?
Answer Posted / 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 View All Answers
Give me sm ideas to write Vbscripts abt protocol testing abilash700@gmail.com.
Mention what is vbscript procedures?
create a form to accept username and password validate the username and password with using message box, display the corresponding user message
1) How can we use VB script in testing the application? 2) What all are the things(Software application to be installed in PC) we need to learn VBscript?
What is the use of the recordset object and which statement is used to create such an object?
Which function is used in the vbscript language to convert the specified expression into a date type value?
What is the technology used by vb script?
What is the purpose of folders object of scripting.filesystemobject class in vbscript?
if u ve resrevation for train and u get a number supose 1234xxxokie.after sucessul entering all required fields. now u put that number in search and want to chk wether these ar same or not if both ar same then its okie otherwise test fail.what would be the vb script code for it to compare these two values of different page.
how to operate webobjects in a webpage using getobject function and then using generic methods?
What are the advantages of vbscript?
Write a test case using Test if the images,a particular test exists,check if the page links match,page response is within a certain range,parameterization of the test,the test should comprise of actions,the test should use a custom function,the test should use global repository
What are the 2 ways to pass a value to the function?
When to use function procedures and what are its characteristics?
Anyone have qtp11.0 crack?