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 |
What is the difference between ByRef and ByVal. When to use ByRef and ByVal
Explain about scrrun.dll?
What is vbscript language used for and which earlier language is it modeled upon?
Is it possible to pass optional argument to function in vb script?
What are lbound and ubound in the vbscript language?
My Salary is 65000. How Much TDS I have to pay
write a vb script to display the code "vbscripting" alphabet by alphabet(i e 1st v then b and up to g)
wat is com(common object model)object for mozilla firefox??? if any knows the exact answer....plz rply me
how to get date format from system locale..format means neither long nor shor... format from system locale. i need like your date is mm/dd/yyyy formate or mm-dd-yy or with time like that. how to get.
write a program to display configuration of a local system with the help of vb script.
Write a program to create a Dynamic array of size 5 elements and display all the elements.
Explain a few date functions in vbscript