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 |
how to get the particular chr in an array list the question is ....i have an array like this ABCD EBCF GBCH IBCJ HERE I NET TO GET ONLY "BC" FROM ALL HOW TO GET IT HELP ME ANY ONE THANKS
Can we Test Welcome Screens and Process Images with QTP
Reverse string without mid or streverse function.
what are the disadvantages in QTP 9.2?
How to open a new test using quicktest professional?
WHAT IS SMATR IDENTIFICATION? plz EXPLAIN BRIEFLY? IS IT POSSIBLE in QTP? HOW AND WHEn THE SITUATION U R USING EXPLAIN WITH EXAMPLE?
How does QTP identifies the object in the application
i have read that "non-reusable actions can not be called in any other test".but in 'call to copy action' copies non-reusable action in other test also..can u pls help to understand this..
How do I modify a value of an elemnt which is not the first one in xml file? My sample XML file is like: <Environment> <Variable> <Name>Name</Name> <Value>Uday Kumar</Value> </Variable> <Variable> <Name>Designation</Name> <Value>Senior Software Engineer</Value> </Variable> </Environment> for example, I'd like to change the value 'Senior Software Engineer' to 'Student' in the second element. How do I do it in QTP?
What is the use of "Define new test object" in QTP 9.1 When should we use? Explain?
w is fragmentation and paging
difference Between Call Run action and copy of action?