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
- 4617 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 |
How to use transactions in qtp?
object types is used for what?
hi this is srinivasa(from blr) i complited my B.tech(e.c.e) in 2007 im searching job in s/w testing but idont have freshers resume for s/w testing please send some s/w testing resume for me(fresfers resumes only) advns thnks you
If the web applicatoin takes navigation time above 2 hours to dispaly next Web page then how can we synchronize the QTP with Appilication Under Test
What is the difference betweent test and component?
How to find given string is palindrome or not without using strreverse() function?
How can i select multiple values from drop down list using vb script in qtp? and wt is the script for clicking msg box box automatically with a specific time. Thanks in advance...Kalyani.
How to create Userdefined Function.Please write the steps ans also provide example where exatcly we use it.
how to find that tools work well with ur existing system?
What is Description Object?
I have one question as HP QTP is concern, Please send your answers..... Can we do testing of any application without using any of the framework which are we used in QTP tool. If yes then how it can be possible in the HP QTP tool. -- Regards
Flight reservation using input and output parameter script.
WinRunner 
