How open an excel sheet in QTP(not a run time )?
Answer Posted / cxv
Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.Application.Visible = True
Set ExcelBook = ExcelApp.Workbooks.Add
ExcelBook.Worksheets(1).Cells(1,1).Value="A"
ExcelBook.Worksheets(2).Cells(1,1).Value="Ra"
ExcelBook.SaveAs "C:\test1.xls"
ExcelApp.Quit
Set ExcelApp = Nothing
msgbox "Completed"
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to find the path of folder in which the test is saved in qtp?
How to analyzing the checpoint results?
How does quicktest professional identifies the object in the application?
What is clean sweep?
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
Can anybody let me know how to test the Drag and drop feature of the column in a .net application...eg..i hav to test the drag and drog feature of a table(swftable) in a application..plze help!!
what is error and fault in terms of software quality?
How to creating an output value using quicktest professional (qtp)?
Why script error occur in between recording in qtp?
how to test use the quality control .how to verify the image verification
Hi All, How to Compare two strings character by character in QTP
What are the ways you can synchronize?
What is fragmentation and paging?
Explain the N-tire structure(process) for Funds Transfer ( means give N ways to funds Transfer in an Application)
To which environments does quicktest professional supports?