Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel - find
Message
De
05/10/2004 20:31:32
 
 
À
05/10/2004 18:32:21
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Divers
Thread ID:
00948975
Message ID:
00948994
Vues:
12
After a while of trying different codes, this is it:

oexcel.Cells.Find("texttofind").Activate

I love intellisense. Hilmar, even though I have done what you suggested many times before, getting the coding right for Foxpro can take some time (at least for me). Actually, what I found helpful was in VFP8.0, create the reference to the excel object using the command window, open the document (still in the command window), and then try a bunch of variations on the macro code until you get it right (all the time checking the excel worksheet - which of course you need to set the visible property to true in order to do this).

One other point - there are a bunch of parameters after the "find" portion of the code that I have not included. This will take some more looking into to ensure that I get them right, but for now, this code works.

Paul
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform