Actually, I am not sure either. But I am answering because I want to point out (just in case you don't know it) what should be the basic approach, to find this out.
First, open Excel and save a macro. Then take a look at the generated macro, and see if you can adapt it to VFP.
My article on Excel Automation -
http://www.utmag.com/wconnect/wc.dll?9,7,10,1562 - gives some more details.
>Can anyone provide me with the code to do a find in excel from foxpro?
>
>lcfile = getfile()
>oexcel = createobject("excel.application")
>oworkbook = oexcel.workbooks.open(lcfile)
>
>Now if i want to search for text within the excel file, i am not sure what the code is to do that.
>
>Any help would be appreciated. Thanks.
>
>Paul
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
