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
>