Function Excel in VBA (1 Viewer)

M

mfuada

Registered User.

Local time

Today, 12:56

Joined

Feb 4, 2009

Messages

63

• Feb 6, 2009

• #1

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

Super Moderator

Local time

Today, 06:56

Joined

Jul 10, 2007

Messages

5,906

• Feb 6, 2009

• #2

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

blah

Local time

Today, 06:56

Joined

Jun 15, 2004

Messages

1,414

• Feb 6, 2009

• #3

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

 

M

mfuada

Registered User.

Local time

Today, 12:56

Joined

Feb 4, 2009

Messages

63

• Feb 9, 2009

• #4

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