Problem with user functions in Add-ins for multiple persons

[EEL1966]

A work I have made many user functions and I have placed them i
different add-ins so they appear in Excel in their own group when yo
choose “function”.

I have then also made a macro that is used for updating by copying th
add-ins from a network place to a person’s computer. Thereby the perso
can use the functions without having network access.

The add-ins is put in the following place on a person’s computer:
C:\Documents and Settings\*XXX*\Application Data\Microsoft\AddIns
where *XXX* is the reference for that person. This is the Microsof
default place.

One of the functions I have made is a Catmul Rom Spline. If person *YYY
uses this function and then sends the Excel file to person *XXX* th
function appears as:
='C:\Documents and Settings\*YYY*\Applicatio
Data\Microsoft\AddIns\Interpolation.xlam'!Catmull_Rom_Spline($S$15:$S$22,O15:O22,$S$24)

The result is that *XXX* cannot make calculations before the followin
is removed
'C:\Documents and Settings\*YYY*\Applicatio
Data\Microsoft\AddIns\Interpolation.xlam'!
So the formula only reads
=Catmull_Rom_Spline($S$15:$S$22,O15:O22,$S$24)

I am looking for a solution to this problem so we can send Excel file
to each other and still use them. I do not want to put the function
into the Excel file. This is why I made the add-ins.

One solution I can see is to put all the add-ins in the following plac
on all computers
'C:\ AddIns
This might solve the problem. This will however result in that all wh
look-on to that computer has access to the add-ins. It is possible fo
me to look on a colleges computer when we have network access.

I am hoping that one of you have a solution where the add-ins can remai
in the correct place

 

[GS]

Addins can be stored wherever you like and so just choose a location.

If you want to simplify this, just store them on a network share and
have everyone use the same one. It will be necessary, though, to
choose *NO* when asked if you want to copy the addin to the local
machine. Of course, you will have to delete/move these from the local
folder so next time you open the AddinsManager Excel will ask you if
you want to remove them from its list. Be sure to tell Excel to delete
it, then close the dialog, then close Excel. When you reopen Excel and
the AddinManager, add the file on the network share one at a time
without copying to the local machine.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion