Function Excel in VBA

[mfuada]

Hey guys is there anyway i could put Excel function in Access?
like function for financial like:YEARFRAC, COUPNCD,etc
could anyone give me a suggestion?
Thanks

 

[Rabbie]

You could try setting the Excel library in your VBA references. You set the references from the VBA editor under Tools-->references. Just click on the appropriate library to add to the reference list.

 

[chergh]

Yeah adding a reference is your best bet. Not all worksheet functions are available this way though, networkdays is one function that springs to mind that isn't available and from a quick look I don't think the two functions you mentioned are available either

 

[mfuada]

Okey i see.... Could you guys give me any example of how to use it in access...