if the excel sheet specified in script is not there,we get run time error how

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

Question Posted / jaya

2 Answers
5648 Views
Quinnox, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

if the excel sheet specified in script is not there,we get run time error how to handle the error ..

Answer / rayudu

Use on error resume next

Is This Answer Correct ?

3 Yes

1 No

if the excel sheet specified in script is not there,we get run time error how to handle the error ..

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

Post New Answer

More QTP Interview Questions

Now it appears to be more than enough... I have learn entire QTP, I did whatever I could do but still facing lots of problem and those problems could be removed only after working in professional atmosphere. But still unable to expose myself as professionaly. It is becoming panic, It has been two years I am in manual testing and looking for the change but all the recruiters ask for QTP, but my problem is I don't have working experience with QTP. Kindly suggest me I really need effective suggestions. I dont have more caliber to work with present organization cause of salary reasons...boo.. hooo...hooo. My email address is alkaa.dugaal@gmail.com

0 Answers

Hi all, I am New to QTP . I am Now in critical situtaion. I want to know How to create our own object respository for our application. please say the answer with example.

3 Answers

how to find that a file has been completely downloaded or not? I told that "download Complete" pop up. but he told the tool doesn't recognize the pop up

1 Answers Mphasis,

What are the challenges do we face while testing webbased applcations using the automation tool QTP or any?

1 Answers

Give the syntax to load function at run time.

0 Answers

What is difference between Quality centre and Test Director?

1 Answers Nokia,

What is synchronization point in QTP?

0 Answers

If 3 browsers are opened in our system, how to enter the facebook url into second browser by using descriptive programing

3 Answers Mind Tree,

What is vulnerability?