Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Find in Excel.
Message
De
15/02/2001 04:50:43
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Divers
Thread ID:
00475826
Message ID:
00476181
Vues:
37
>>How to use the find function from excell in vfp.
>>I want to find an expression from A1 to Ax.
>
>You'll want to set a Range object to A1 to Ax, as in:
>
oRange = oExcel.ActiveSheet.Range("A1:A25")
>Then you'll use the Find method:
>
xSearchFor = "My Text" && can be any Excel data type
>oRange.Find(xSearchFor)
>See the Help file for more parameters that help you fine-tune Find (can search the forumlas, values, or comments; search forward or backward; match case; etc.)
>
>HTH,
>
> - della
Thanks.
Its works fine.
Bu i have now another problem.
Do you know, how can i know the result from the find method.
Thanks.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform