Interested to Buy Any Domain ? << Click Here >> for more details...
how to open Excel sheet & write in it & save it?
- 1 Answers
- 7053 Views
- InTech, I also Faced
- E-Mail Answers
Answer Posted / guest
Set excel = CreateObject ("EXCEL.Application")
excel.Caption = "Test Caption"
excel.Visible = True
Set doc = excel.Workbooks.Add()
Set selection = excel.Selection
With selection
.Cells(1,1).Value = "Test value"
End With
doc.SaveAs("E:\Excel.xls")
excel.Quit
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
How the smart identification is used in real time?Please explain with an example
i am new QTP... please tell me automation frameworks , types & for whiich type of applications frameworks are used & how to generate script in keyword driven framework
What are the various types of Actions in UFT?
1. What is the difference between Keyword and function in the keyword driven framework? 2. How do you associate Keywords to the script ?
you are recording on "WINDOW 1", say it has a link if you click on that, that leads you to "WINDOW 2". If you do any manipulations on "WINDOW 2" that are automatically updated in to "WINDOW 1". But "WINDOW 1" is currently invisible. But the updations in "WINDOW 1" must also be recorded as a script in QTP. The best Example is if you update your resume in JOB STREET portal it actually happens in other window, but the previous window is automatically updated. Now does QTP help you in this types of situations? Any body can answer this question. please..... Siva
In qtp, explain what is keyword driven automation framework?
what is the hierarchy to use properties in descriptive programming
what type of automation is follwed in the project?
Pls can anyone give me the entire code for the Keyword driven framework with respect to he Flight Reservation Window in detail with explanation. Pls explain in detail stepwise. Thanks a lot. Pls very urgent?.
Hai anyone please "Explain about Framework in QTP?"
What is expert view and keyword view?
What are the common defects found in your project? (in qtp interview)
Why do we use "Text checkpoint" If we can make use of it in "standard checkpoint" ?
What are the different types of recovery operation?
Subj: realtime example of Database check point, Can any one please detail on how the Database check point is utilized/implemented in a real time project. I already know how to make one by creating DSN/ODBC and writing the required query manually and other steps...I wanted the actual concept of implementation...couple of live examples will be highly appreciated. Thank you in advance
