>>>I am wondering if there is a way to have a VFP application through COM open an excel sheet and quickly identify certain cells. I don't want to go through the entire sheet cell by cell looking for what I need. I could try to do a find, but I wonder if there is a better way. In word I could create bookmarks, but I don't see that in excel.
>>>
>>>Cesar
>>
>>In Excel you can apply a "name" to one, or a range of, cells. Will this give you what you need?
>
>Yes, it might, can you then search for that name and it will give you the cell location?
I hardly use Excel and I can't say for sure, but it seems logical that you would be able to get the cell's location, given its name.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
