Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find in Excel.
Message
From
15/02/2001 04:50:43
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00475826
Message ID:
00476181
Views:
38
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform