vb macro error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

r@d - 27 Jan 2006 20:21 GMT

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&)

Reply to this Message

JE McGimpsey - 29 Jan 2006 14:04 GMT

> 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
[quoted text clipped - 10 lines]
> 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...

Reply to this Message

Mac Forum / Applications / Excel / January 2006

vb macro error