with out using import sheet came is it possible to get the
excel sheet ?
Answers were Sorted based on User's Feedback
Answer / chaitu.c
Dim ExcelObj
Dim ExcelWB
Dim NewSheet
Set ExcelObj = CreateObject("Excel.Application")
Set ExcelWB = ExcelObj.Workbooks.Open ("D:\Documents and
Settings\Administrator.SEERVER\Desktop\Test.xls")
Set NewSheet = ExcelWB.Sheets("ranga")
NewSheet.Cells(1,1)= "CHAITU"
ExcelWB.Save
ExcelObj.Quit
Set NewSheet = Nothing
Set ExcelWB = Nothing
| Is This Answer Correct ? | 2 Yes | 2 No |
What is checkpoints for qtp?
Plz explain about MATCH/EXACT MATCH/IGNORE SPAGE in text check points?
What are the Test design techniques you uses in ur project?
How can i use virtual objects? If have i created one new virtual object in a virtual object manager by following instructions.
what will be there in keyword view and expert view?
Thanks....But can u tell me how i use the QTP for GIS with one Example...
h u call the function
if our qtp vb Script may be Currepted then What we want do?
suppose our project is developed using java technologies.after complition of the coding developer relesed a build to the testing team.so, what is the process means how we open that documents?what are that documents?plz give reply its urgent
what area in a web application cannot be automated.
Please let know the scripts for counting number of repeated letters in the word. Note repeated letter should not be count agian. Ex: If "Hello" is my word... l is coming twice.. it should count once and print... secong 'l' should not count again..
In an application you have a web table. You are provided with an external Excel sheet with the same structure as that of the web table. How will you retrieve all data from the web table and compare it with corresponding data available in the excel sheet, using QTP? How will you report the results in QTP?