10-07-2009, 03:21 PM
Simple query repeated a 1000 times..Anyways i will give you the logic, go ahead and build your code.
1. Exploit Excel COM component (Excel.Application)
2. Set reference to the active workbook and then to the active worksheet.
3. find the total row count.
4. Use the For loop to loop through and read through the rows and cells.
5. Compare the data retrieved to match with the one you need.
Search this forum with the keyword Excel, read and build your code from the clues i have supplied.
1. Exploit Excel COM component (Excel.Application)
2. Set reference to the active workbook and then to the active worksheet.
3. find the total row count.
4. Use the For loop to loop through and read through the rows and cells.
5. Compare the data retrieved to match with the one you need.
Search this forum with the keyword Excel, read and build your code from the clues i have supplied.
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.