Add-in functions path

[r@d]

I have an excel add-in which contains functions I need for work. These
functions are used in several workbooks which must be shared by several
users. All users have a copy of the add-in installed. Recently I
started using a mac (os X 10.3.9 office 2004) and the following error
popped up. When I open one of these shared spreadsheet after it has
been saved by a windows user all the formulas which used the functions
from the add-in now have the full path to the add-in file on the mac
computer followed by the function name, ie. macos
X:filepath:example:addin-file-name!function. If I delete the
path/filename the function works correctly. Unfortunately, when I save
the workbook and a windows user open it, then now have the full path to
the add-in file on <i>my mac</i> preceeding the function in the
worksheet formulas.

Obviously this makes work difficult. Do have something misconfigured on
my mac? Does anyone know what to do about this apparent
incompatibility?

Any help would be appreciated

 

[Mike Middleton]

r@d -

This sounds like very standard behavior for User Defined Functions. When the
XLA file is not located at exactly the same path, you could use Edit | Links
to change the reference.

- Mike
www.mikemiddleton.com

 

[r@d]

So if two windows users were sharing a workbook that used a function
defined in an add-in and the these two users stored the add-in in
different file locations on their systems they would have the same
problem?

If this is true then Excel doesn't work like I thought ( and like I
still think it should). It seems like once you have an add-in loaded,
you should be able to use it's functionality without regard to where
the add-in actually is.

 

[Mike Middleton]

r@d -

So if two windows users were sharing a workbook that used a function
defined in an add-in and the these two users stored the add-in in
different file locations on their systems they would have the same
problem? <

Yes, that's the situation for VBA User Defined Functions in an add-in.

If this is true then Excel doesn't work like I thought ( and like I still
think it should). It seems like once you have an add-in loaded, you should
be able to use it's functionality without regard to where the add-in
actually is. <

Only the functionality of User Defined Functions is affected. Other features
of an add-in (e.g., features used via a menu command) are not.

As I recall, functions in a DLL that are registered using an add-in also are
not affected.

- Mike
www.mikemiddleton.com