>Does anybody know how to produce the Excel IRR function in Foxpro?
>
>Thanks for any help.
>Hans Verkoijen
You can execute it in Excel with automation. For example, the MIN function would be called like so:
oXL = GetObject(,"Excel.Application")
myRange = oXL.ActiveSheet.Range("B1:B5")
? oXL.WorkSheetFunction.Min(myRange)
HTH