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
Key word driven framework
How to add synchronisation points in qtp?
what is meant by source control?
What are the major/ important methods, functions in QTP we use realtime testing
I want to test my vb.net solution file using qtp. Does Qtp test only .exe file?
I have created 3 actions in test action1, action2, action3 but I want run action 1,action 3,action2 how can you change in the actions in keyword view?
Give the syntax to import/export xls into qtp.
How many add-ins comes by default with quicktest professional?
What processes will be required to manage updates to the web site's content, and what are the requirements for maintaining, tracking, and controlling page content, graphics, links, etc.?
What is the new version of qtp which is recently released in the market?
How qtp identifies objects?
Do you know how to connect database? Can you tell me the procedures?
i have two questions for regular expression :- Q1. I have date pattern eg-29/11/2011 29-11-2011 29.11.2011 Que- if any separator is there between date,month and year pattern should match else it should not match eg- pattern should not match in case of 2911-2011 Q2. let say i have a string and there is a number in between of that string eg.-Amount 30002.234 successfully credited to your account . now i have to match this pattern in such a way that even if decimal is not there pattern should match ,how i will do this using regular expression
How to capture dynamic values in load runner and how Each of the captured values are to be written to a text file (c:\temp\LoadRunner1.txt)
How to open a new test using quicktest professional?