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
what type of automation is follwed in the project?
how interviews will be on QTP?
What is the use of text output value in quicktest professional (qtp)?
What does mean by Scope of Automation?n How we defined it?
How do I get the QTP scripts result in xml format by using vb script function?
what is the difference betn QTP 8.0 AND PREVIOUS VERSION
What are the 3 main stages involved in testing with qtp?
How can we extract data like "Details","Result","Time" from the 'Run Error' result generated in QTP after run time errors are generated during a run & import the details etc...into excel sheet
What is the difference between shared and local object repository?
Can you write a script to check if the folder exists or not?
Both static and dynamic arrays are handled by the vb script. Is it true?
What is Curd testing?
How to find the path of folder in which the test is saved in qtp?
If an application name changes frequently i.e while recording it has the name, in this case, how do qtp handles?
Hi all, I am using windows vista, I am in the process of learning QTP. When ever I try to work with insert mode in flight application , i am getting the error of 'Operation must use an update table query, fractional truncation(null) error. Can anyone help me regarding this?