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

Why bpt?

807


Can the user toggle between using Local OR and shared OR for the same action?

748


What are the ordinal identifiers in web page?

842


Where is the Bitmap checkpoint information stored?

1980


Have you done batch testing in qtp? If yes how you are doing?

702


How to build scripts that access data from external sources?

1822


Define object spy ?

755


What is the difference between qtp and selenium?

771


What is an object repository?

815


Hi All, How to Compare two strings character by character in QTP

1247


How to check bitmap output value?

860


how to do the batch testing in test director using manual testing procedure?

2019


if anyone has idea of the interview procedure in covansys, plz send me a mail?

1731


What are the major/ important methods, functions in QTP we use realtime testing

2502


Did QTP prove efficient for your project? Yes or No, explain?

6333