Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem with user functions in Add-ins for multiple persons
A work I have made many user functions and I have placed them in different add-ins so they appear in Excel in their own group when you choose “function”.
I have then also made a macro that is used for updating by copying the add-ins from a network place to a person’s computer. Thereby the person 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 Microsoft 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 the function appears as: ='C:\Documents and Settings\YYY\Application 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 following is removed 'C:\Documents and Settings\YYY\Application 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 files to each other and still use them. I do not want to put the functions 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 place on all computers 'C:\ AddIns This might solve the problem. This will however result in that all who look-on to that computer has access to the add-ins. It is possible for 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 remain in the correct place. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with user functions in Add-ins for multiple persons
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[s]. 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[s] 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User defined functions that are array functions | Excel Programming | |||
Dividing a value list equall among multiple persons | Excel Discussion (Misc queries) | |||
Email to multiple persons | Excel Programming | |||
How can I e-mail multiple persons whose addresses are in excel? | Excel Discussion (Misc queries) | |||
User Defined Functions - Help Text - Make it Easy for the User | Excel Programming |