See the article about how to use Excel functions from VFP in the Article section at www.foxite.com. It may contain approaches that you need.

>All,
>
> I have a program that needs to call a public custom function in an Excel spreadsheet. I can open the excel file, but am not sure how to call the function since it's not a macro. How do I do this?
>
>Here is the code I have
>

>....
>    With oExcel
>        .Workbooks.Open ("C:\calledfromaccess.xls")
>        .Visible = True
>        lnresult = .Run("MyCalcSum", 1, 3)
>        .Quit
>    End With
>