Interested to Buy Any Domain ? << Click Here >> for more details...
Can any 1 modify the code whr in want to add\rename a excel
sheet in qtp?
- 1 Answers
- 3950 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 |
Which conditional statement is the most convenient one to use in the case of multiple conditions in the vbscript language?
Why is the use of exit do or exit for statements within loops discouraged?
what is the differenece btwn scripting language and programming language
i need to login to my yahoo accoutnt using VB Script, automating the operation of webobjects, even launching of IE. How?
What is the technology used by vb script?
What are class events?
can anyone tell me the procedure of interview held in applabs
compare the string without using stringcomp function?
1.I want to establish connection with excel and also want to fetch the data using SQL queries. 2.the code should be written in such a way that in future if I want to migrate from excel to MS excess database , then there should be minimal changes.
What is wrong with the following code: <%afname="header.asp"%><!?#include file ="<%=afname%>"?>
Explain the constants in vbscript?
Is VB Script Case sensitive or Case insensitive?
ASP 
