Hi All,
At work there is acustom addin for a UDF that we all rely on.
The addin, when it gets called correctly works as desired.
However there are issues, depending on where the user stores the Addin.
As I understand the:The functions returns a #NAME? value depending on where individual user stores the Addin and saves the relevant spreadsheet. The person who next opens the spreadsheet should have the Addin stored in the same position else the #NAME? problem occurs.
- default MS defined Excel ADDIN path is
- C:\Program Files\Microsoft Office\OFFICE11\ADDINS (C Drive).
- All our computers are set up so that the default Addin in path is
- D:\Documents and Settings\[user name]\Application Data\Microsoft\AddIns (D Drive).
How can this problem be fixed, I am thinking of recreating the Addin, so that it will work regardless of where the user places the file (rather than ask everyone across the firm to place it in a certain location).
Is this possble? If so could anyone please offer some guidelines?
regards