New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › VB Scripting/Descriptive Programming v
How to search a value in excel sheet using vb script

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
How to search a value in excel sheet using vb script
venkatbatchu Offline
Member
***
Posts: 240
Threads: 38
Joined: Jun 2009
Reputation: 0
#1
Solved: 11 Years, 4 Months, 3 Weeks ago 10-07-2009, 03:02 PM
Hi All,
I have 10000 records in excel sheet, here i need to search for a paricular value in this 10000 records and if it finds a record then it has to fetch the row and coloumn of that specific value and it has to search until it reaches the 10000th record once it is finsihed then by this time i need to fetch all the row and column of the matches data

Please help me in this reagrd...

Thanks in advance,
Venkat
Find
Reply


Messages In This Thread
How to search a value in excel sheet using vb script - by venkatbatchu - 10-07-2009, 03:02 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  how to select value from google search box dropdown +QTP prajyot 0 2,925 06-28-2017, 06:30 PM
Last Post: prajyot
  Trying to create List box in excel sheet at Run time with values yes No JACKSPARROW 0 1,738 01-17-2017, 11:05 AM
Last Post: JACKSPARROW
  Search and import data from excel under some rules. nwpulele 2 2,976 02-19-2015, 04:10 AM
Last Post: supputuri
  Excel and Driver Script shipu 1 3,866 02-27-2014, 09:09 AM
Last Post: supputuri
  Custom sort -Excel Sheet kiran 1 3,900 01-28-2014, 09:23 AM
Last Post: supputuri

Forum Jump:


Users browsing this thread: 3 Guest(s)