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 |
Mention what is variant in vbscript?
Which is the default Data types in VBScript?
Write a Program to add 2 numbers without using operators (+,-) and without using third variable. Note: Use VBScript only Hint: You can use other operators like '/' & '*'(Division & Multiplication)
In what way program "hello world" you can write in vbscript?
How to Import data from a file (file is on the desktop) to the data table
how to set one column as primary key in QTP and fetch values accordingly
Difference between Do while loop and while wend loop
how does vb script help in web page designing? explain with example.
write a vb script to generate hello 5 times using do until loop
Write a VB Script to count blank Lines in a notepad
Check whether given Number is Even or Odd?
I have a webtable and many objects are embedded in side.(like buttons,checkboxes etc). How to know how many such objects are there? what is the class of that objects?