How can we check whether a particular sheet loaded (existed)
or not in Data Table.

Answer Posted / madhulika

On Error Eesume Next
datatable.getsheet("Sheet name")
'Checking error number, if no error then returns 0
If err.count<>0 Then
msgbox "Sheet not available"
Else
msgbox "Sheet available"
End if
On error go to 0

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

is it possible to add sheets to excel at runtime

3242


How are cgi programs, applets, javascripts, ActiveX components, etc. to be maintained, tracked, controlled, and tested?

707


How is the Bitmap checkpoint different from Image checkpoint?

630


how to acess a test in RSA?

1676


In Test Directory, What are the contents in test case designing? if you prepare in excel sheet how u use thrw Test Directory?

1510






Excel sheet having some datas and some datas present in the application (in table). How will you compare these two datas? Write code to fetch datas from Excel sheet.

1506


Describe how Smart Identification is used

1702


what is clean sweep?

1891


How to Test the mainframe application?

1830


Can any one tell me.......How the test engg's start testing in the compy environment.....real time tester PLSSSS help me i need in depth information regarding this...

1500


if mandatory and Assitive propertys are shows same how will u write skript in QTP window

1628


Hi we are running tests remotely from quality center and pushing tests into qtp boxes remotely, and it does execution but while uploading results back into quality center it hangs in qtp box.If any one come across similar problem, please send me details how to handle this. Thanks kris

1751


Whar are the challenges do we face while testing web based applications using the automation tool QTP or any??

1644


in a web page How to check and display a particular word from a paragraph?

2054


Explain about the quicktest professional (qtp) automation object model?

574