I am trying to do this is my program.
Open an Excel File
Search for a value in the excel file
When i find the value i want to know the location of that value.
For example if my excel file has 3 values
When i search the file for orange..it should say that orange found and return me the value A2.
I am not able to find the location.
Get the row and column number
Replies are listed 'Best First'.
Read the Excel object model documentation. For a cell (or Range) there likely is a function returning the coordinates of the upper left corner. Maybe it's Cell->Address or something containing R1C1 in its name.