Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel COM automation - bookmarks and quick searches
Message
De
05/09/2000 14:10:47
 
 
À
04/09/2000 12:44:06
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00412211
Message ID:
00412584
Vues:
18
I don't have an example in front of me. But I know you can do a "go to...range name". Just fire up a macro in Excel and copy it out.

PF

>>>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?

(On an infant's shirt): Already smarter than Bush
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform