vb macro error

[r@d]

I'm trying to use an excel add-in from work which was developed on
windows office 97. It works correctly in windows, but when I try to
install it on my mac I get the following error:

Compile error: Can't find project or library.

The vb debugger stops at the function definition. I'm not a vb
programmer. Does this look wrong to anyone? Particularly is there
anything here which would balk on a mac but not on windows?

Function Factor#(ByVal Age#, ByVal iRate#, ByVal MortTable$, Optional
ByVal CCYrs#, Optional ByVal DefAge#, Optional ByVal Age2#, Optional
ByVal JSPer#, Optional ByVal JSCC%, Optional ByVal MalePer, Optional
ByVal SetBack&, Optional ByVal MortTable2$, Optional ByVal SetBack2&)

 

[JE McGimpsey]

I'm trying to use an excel add-in from work which was developed on
windows office 97. It works correctly in windows, but when I try to
install it on my mac I get the following error:

Compile error: Can't find project or library.

The vb debugger stops at the function definition. I'm not a vb
programmer. Does this look wrong to anyone? Particularly is there
anything here which would balk on a mac but not on windows?

Function Factor#(ByVal Age#, ByVal iRate#, ByVal MortTable$, Optional
ByVal CCYrs#, Optional ByVal DefAge#, Optional ByVal Age2#, Optional
ByVal JSPer#, Optional ByVal JSCC%, Optional ByVal MalePer, Optional
ByVal SetBack&, Optional ByVal MortTable2$, Optional ByVal SetBack2&)

There's nothing in what you've posted that won't run in MacVBA.

It's hard to suggest other places to look, since you're not familiar
with VBA. I'd be willing to look at it if you wish. Send me an email
from your real email address and I'll give you instructions on sending
the add-in as an attachment so that it will get past my filters...