Interested to Buy Any Domain ? << Click Here >> for more details...
1.How to find in which row or column,string "Hyderabad"
exist in excel sheet?
2.How to find how many times character "a" repeated in a
given string "Koteswararao"
- 6 Answers
- 14341 Views
- Ness Technologies, I also Faced
- E-Mail Answers
Answer Posted / lak
1)Find Cell data(Hyderabad)
dim obj,objwb,objsheet,search_item,found,flagrow,flagcol
Set obj=Createobject("Excel.Application")
Set objwb=obj.WorkBooks.Open("D:\Find.xls")
Set objsheet=objwb.Sheets("Sheet1")
obj.visible="True"
search_item="HYDERABAD"
set found=objsheet.Cells.Find(search_item)
On Error resume next
flagrow = found.Row
flagcol = found.Column
msgbox "Location Is : ( Row : "&flagrow&",Col :"&flagcol&")"
objwb.Save
objwb.Close
Set objwb= Nothing
'-----------------------------------------------------------
2) Repeated Character
str="Koteswararao"
repcnt=Split(str,"a")
Msgbox "Count :"&ubound(repcnt)&""
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In Test Directory, What are the contents in test case designing? if you prepare in excel sheet how u use thrw Test Directory?
please any one can explain the keyword driven framework. with gmail example.
In an interview, what r the general questions asked in QTP? pls give me anwser to this question?
hi i am working with vbwindow on qtp.first i am openning qtp whenever open qtp my application not open that time generated error like "Runtime error 0" and fatal error:automation error how to solve this problem pls tell me
Hi I have exp in manual testing and planning to move in automation testing qtp(9.2).So can help me how to automate customer relationship management tool using qtp and vb script this tool already developed so how can I test it whatever maintaining by development team like documents,various options just give the whole life cycle thanks in advance
Diff b/w Health care domain and Banking Domain?
How to analyzing test results using quicktest professional (qtp)?
How to use descriptive programming?
Hi Friends, How many types of Data Bases available in market... What is the diff. while using Syabase and Oracle in a Project... ? and what is the main diff. of Syabase and Oracle databases... ? Thanx in advance..
in my application,validation message has in japanise language.how to validate this message is appears properly or not
What are the methods of the TextStream object that are used for reading from a text file?
Plz Explain AUTOMATION REFERENCE MODEL?
1.How do u prepare the test suits in QC? 2.How do u convert requirements to test plan in QC?
Explain different type of event trigger option.
What is the purpose of loading qtp add-ins?
