Information générale
Catégorie:
COM/DCOM et OLE Automation
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement