XIRR code for access

[kev777]

I've been trying to find the code for the excel function XIRR but can't find it anywhere. Can anyone help?

Thanks.

 

[MichaelRed]

In general, you can just add the excel library to the referencs for Ms. A., and 'dhe' will execute the functions 'as if' native VB code. Since [XIRR] is one of the Tool-pak addins, I suspect that it is in some other library. The argument list syntax suggests that the function will work in ANY program - IF you cna figure out what library to add to the references.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over