with out using import sheet came is it possible to get the
excel sheet ?
Answer Posted / 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 |
Post New Answer View All Answers
Why bpt?
Can the user toggle between using Local OR and shared OR for the same action?
What are the ordinal identifiers in web page?
Where is the Bitmap checkpoint information stored?
Have you done batch testing in qtp? If yes how you are doing?
How to build scripts that access data from external sources?
Define object spy ?
What is the difference between qtp and selenium?
What is an object repository?
Hi All, How to Compare two strings character by character in QTP
How to check bitmap output value?
how to do the batch testing in test director using manual testing procedure?
if anyone has idea of the interview procedure in covansys, plz send me a mail?
What are the major/ important methods, functions in QTP we use realtime testing
Did QTP prove efficient for your project? Yes or No, explain?