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.
in reply to Use The Macro Recorder, Luke (Re: Using Win32::OLE and Excel - Tips and Tricks)
in thread Using Win32::OLE and Excel - Tips and Tricks