Hello!

I have a excel add-in with a few User Defined Functions.
The add-in is used by ten different users.
I have placed the add-in in the XLStart folder on each client machine
(C:\Program Files\Microsoft Office\OFFICE11\XLSTART).
My UDF looks like this in the formula field:
=GetCustomerName(A4)

When saving a workbook from one computer onto a network drive and then
opening the same workbook on a different computer, I have problems. When
opening the workbook on the other computer, the UDF looks like this:
='C:\Program Files\Microsoft
Office\OFFICE11\XLSTART\MyXLA.xla'!GetCustomerName (A4)

So the path of the xla is saved in the formula field. That would be OK if
the UDF could resolve the formula. But I get an error:
#NAME
in every cell where I have the UDF.

If I remove the path of the .xla the function can be resolved, but the error
returns if the workbook is saved and then opened on another computer.

I think I am doing something fundamentally wrong here, please enlighten
me...


Regards

L-E Eriksson