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 |
write a function to read the items from Combobox of Flight Reservation application and save in excel.
what is batch testing?
What is the QTP test frame work?
HOW TO DO THE BATCH TESTING USING QTP?
What is an environment variable?
How u perform Batch Program in QTP?
What is the exact difference bet function and action in QTP Anybody can explain it in detail..Thanks in advance..
recording is not a good programming practice.How to write effective script without recording.Which is the correct method explain in detail
How will internal and external links be validated and updated? how often?
how to lunch the application in the qtp tool ?
I have developed and executed a script successfully, and saved the same to QC. When I tried to execute the script from QC, the script is not executing. What are the possible reasons?”
I have a WebEdit Object.It is added in object repository.It has two properties Name and Index.In the next release the Name Property is same but the index property is changed.when i run the script will the script Pass or Fail