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
- 3966 Views
- I also Faced
- E-Mail Answers
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
Can someone please tell me what poor design in a relational database (not the layout or style) is and how it can be avoided? PLEASE...im desperate.
What are the special sub-types in vbscript?
I am working on QTP, got struck in one place.. In my application depending upon configuration WebEdit count is increasing/ decreasing.. how to get these webedits..
Please let me Know regarding any material regarding VB Scripting which should be easily understandable for Beginners.
Hellow friends, I am learning QTP,but here problem is VB script. please guide me how to learn VB script w.r.t QTP and if you know any books tell me or if you have any materials or any use full material or any else w.r.t QTP please post me p.p.sekhar
Explain about vb script?
By default in vbscript the arguments passed to functions and subroutines are by reference or by value?
How to Enter Values on the Command promt using VB script
what is event handling?
Which date function is used in the vbscript language to find the difference between the 2 dates?
Why is error handling required?
Mention what are the rules to name variable in vbscript?
In the Web page we have a table link, if we click on that link all the contents under that link will be sorted (asscending/Descending). Now i want to check in which order the list is ? for that i need to get the data in to some var How can i get that cells data?
What is loose binding? Why is it not a good practice to use it?
Explain about scrrun.dll?
