Interested to Buy Any Domain ? << Click Here >> for more details...
if the excel sheet specified in script is not there,we get
run time error how to handle the error ,please anybody
explain me in detail
- 2 Answers
- 5751 Views
- Quinnox, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / veeranki naveen
On error resume Next
err.clear
set Excl = createobject("excel.application")
set Workbook=Excl.Workbooks.open("C:\Folder\ExcelFile.xls")
if err.number <> 0 then
msgbox "Excel Sheet is not present at the specified path"
End If
OR
set fso = createobject ("scripting.filesystemobject")
bol = fso.fileexists ("C:\Folder\ExcelFile.xls")
if bol = false then
msgbox "Excel Sheet is not present at the specified path"
End If
msgbox
| Is This Answer Correct ? | 1 Yes | 0 No |
Hi Samrat, Thank u very much, what u said it is right.
Which features or drawbacks of QTP lead to the upgrade for a newer version?
How to use the Object spy in QTP 8.0 version?
HI, Anybody can explain Automation Test Framework...and wht do we do before start of Automation.....
What is parameterization? What is syncronization pt.?
3 Answers Semantic Space, SRM,
Hi Friends, Im planning to do certifcation in mercury Automation Tool QTP.But I Didnt get any clear details regarding course syllabus, fees, where to approach, and which certification would be useful for the experienced testers? can any one send me the details?
Explain about Test Fusion Report of QTP?
How to load the object repository at run time?
I heard that in Hyderabad Ameerpet is renowned for its training institutes it has , but from my own experience I can only say that this institutes have become money making machines losing their cognitive ability and ethics , can anybody tell me is there a good ins. in hyderabad for testing tools.?
give the code to count child objects (Total) in the page
In a web site, Protocal has been changed http: to https: what is your approach?
What are the types of object repositories? Which one is you are using?
WinRunner 
