How can we open an Excel sheet through the script
Answer Posted / uday kumar_anem
If you want to open Excel sheet using QTP, follow the below
script:
Dim objexcel
Set objExcel = createobject("Excel.application")
Set objWB = objExcel.Workbooks.Open("FileName")
Set objWS = objExcel.ActiveWorkbook.Worksheets("SheetName")
objexcel.Visible = True
| Is This Answer Correct ? | 33 Yes | 4 No |
Post New Answer View All Answers
How many types of parameters are available in quicktest professional (qtp)?
Explain advantages and disadvantages kdf?
What is data driver in qtp? Where we use it?
What is the extension of qtp local repository?
what is command for executing files?
Suggest and Define a solution for an application whose objects are not recognized by UFT?
Diff b/w Health care domain and Banking Domain?
What do you to script when objects are removed from application?
What is checkpoints for quicktest professional (qtp)?
Differences between quicktest professional (qtp) and winrunner?
write the vb script for call to new action in qtp?
If the objects hierarchy is changing from build to build, then how you will handle that condition?
How does you test a weblink which is changing dynamically?
If you giving priority as p0, as a developer if I give priority as p2, What happens In user defined function ?
I want to open a Notepad window without recording a test and I do not want to use System utility Run command as well. How do I do this?