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


Please Help Members By Posting Answers For Below Questions

please post the interview questions for QA position in FACTSET

3954


What ate the Technologies supported by QTP?

648


What do you mean by checkpoints in qtp?

563


What are the different recording modes?

564


Hi, can explain the draw back of manual testing.plz send me the answer to my mail id deepthip1985@gmail.com

1419






What is the architecture of your project? Can any one answer for this question plz........

1413


How do you send email with attachment from outlook using qtp ?

565


how could i download qtp in which i get add-in support for 'oracle' is there any way to get it? i finding but not getting pls help me out :)

1435


Hi All , How can we decicde for pariticular frame(DataDriven or Keword Driven)in Project? Thanks Balaji

1378


Explain the concept of object repository & how qtp recognizes objects?

572


write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object..

1802


How to record application running on the Virtual machine?

644


Name the properties you would use for identifying a browser and page when using descriptive programming?

527


Give the syntax to import/export xls into qtp.

588


What is RTM (require ment tracebulity marix) fromate?

1532