Hi,
how about putting XLA in the "Library" folder in the folder where
Excel.exe exists. Application.LibraryPath also returns the location.
excel makes the relative path from this library folder.
--
HTH,
okaizawa

Baj wrote:
Currently we are putting our custom XLA's on each users computer under their
profiles "ADDIN" folder. This is where Excel wants to look when you load
addins. It seemed best to do it that way. We load the addin from the Excel
tool bar so that it loads with excel. When the functions are used Excel for
some reason adds the path to the function as shown below:

'C:\Documents and Settings\dbadge\Application
Data\Microsoft\AddIns\water97_v12.xla'!enthalpySat VapPW(J12)

This causes no end of "Edit Links" "Change source" etc. when others use it.
It is a pain...
How do I make the pain stop...