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)")
Erik Moore
Clientelligence