how to open Excel sheet & write in it & save it?
Answer / guest
Set excel = CreateObject ("EXCEL.Application")
excel.Caption = "Test Caption"
excel.Visible = True
Set doc = excel.Workbooks.Add()
Set selection = excel.Selection
With selection
.Cells(1,1).Value = "Test value"
End With
doc.SaveAs("E:\Excel.xls")
excel.Quit
| Is This Answer Correct ? | 10 Yes | 1 No |
Wher to use DATA TABLE METHODS in Qtp?What is the use of it?
What is the syntax to use out of two characters. Pls anybody can give the answer.. Thanks in advance...
in how many ways you perform batchtesting?
How we know the qtp has used the smart identification process for identification of the object.
what does it mean when a check point is in red color? what do u do?
In QTP, Give the difference of Global sheet and Local sheet in datatable?
In Test Directory, What are the contents in test case designing? if you prepare in excel sheet how u use thrw Test Directory?
I want different types of discriptive programming statments coded for different types of web-objects?Give syntax and example?
Hi How to retrieve data from web element line by line?
how to test one edit box using Java addin for Web Applications? write script?
How to Open FireFox using descriptive programing? If my question is not clear, i will give an Example To Open Internet Explorer, We use Set IE = CreateObject(InternetExplorer.Application) IE.Navigate "www.yahoo.com In the same i need to open yahoo.com in firefox. Can any one tell me what is the server name of firefox to create an object
I have created 3 actions in test action1, action2, action3 but I want run action 1,action 3,action2 how can you change in the actions in keyword view?