Hi Louis,
>I know how to use excel functions when using excel as a COM object, but what I'd really like to do is call the excel functions directly, to perform linear regressions, std deviations, etc. I'm sure that they must be contained in an external DLL
No, they must not be stored in a DLL in a format that is usuable from any other application. After all, Excel provides the COM interface and DDE, why should it provide a further interface. You actually have to use COM. If it's too slow, try to move the entire calculation into a VBA script and execute that script from VFP.
Christof
--
Christof