>>I am sure there must be a direct way to do this:
>>
>>I want to use some Excel functions from VFP, so I am looking for the excel equivalent of FPOLE's FoxEval() function. Something like
>>
>>oXL = CREATEOBJECT('Excel.Application')
>>?oXL.EvaluateExpr("AVG(5:10:20)")
>
>
>just a thought...
>
>createobject excel application
>set visible property .f.
>
>move req. values in cells
>move req. formula in another cell
>move to other cell and retrieve the value from formula cell...
Yeah, I know I can do this. But I don't want to because it's cheesy. And for functions that have to be called in tight loop, this will probably be much slower than calling the function directly.
Thanks for the thought.
Erik Moore
Clientelligence