Excel Add-In problem on other pc

[Puyol]

Hello,

I created an Add-In for Excel 2003. Lets call it MyAddIn.xla
In this Add-In a have a function myfunction().

On computer1, the Add-In is in this folder: C:\Program Files\AddIns\
On computer2, the Add-In is in this folder: C:\test\
On both computers, the Add-In is installed and selected in the "Add-Ins available."

When I create an excel file which uses the function from my Add-In, everything works fine on computer1. Then, I move the excel-file to the other computer and when I open the file, I get the following message:

"This workbook contains links to other data sources.
If you update the links etc..."

And when I look in the cell where I placed my function, I can see the following: ='C:\Program Files\AddIns\'!myfunction()

It seems like the excel on computer2 doesn't recognize the function, allthough the same Add-in is installed on computer2!

Can anyone help me?

Puyol

 

[Andrew Poulsom]

Welcome to the Board.

Try putting the Add-In in the same folder (path) on both machines.

 

[Puyol]

I don't want to do this. Because in the future, people will have it installed in this directory:
C:\Documents and Settings\loginname<LOGINNAME>\Application Data\Microsoft\AddIns.
where loginname <LOGINNAME>is different for every user.