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 |
What is a runtime datatable ?
WHAT IS THE FUNCTION (HOW TO DO) THE BATCH TESTING IN TEST DIRECTOR USING MANUAL TESTING PROCEDURE?
iam have done mba(finance)in 2008. in 2008 one reputed consultancy came off campus interview our institution. i got job as "manual test engineer". now iam working as "manual testing engineer". now my problem is when iam going interview the interviewer asking like " ur mba gradute how can u get job in test engineer." this question i have faced every interview. iam explaining how iam getting job. but they are not trust me". pls tell me answer how i am giving relavent ans.. this is my mail id y.ramana84@gmail.com
What is the basic concept of qtp?
What are the different types of checkpoints?
What are the file extensions for per-action, shared object repository files and what is the extension for library files?
If we put all properties in mandatory and assistive list of Normal Identification, Do we still need Smart?
In qtp, explain what is qrs file?
How to handle Java tree in QTP?
hi can anybody help with an qtp 9.2 license key please. Thanks, Nitesh.
how to write vbscript on web applications in qtp. explian with one example?
What is load testing?