UDFs displaying complete paths

[Faraz A. Qureshi]

I have an addin of several UDFs installed on two computers but when I send a
file to the other via Outlook the other computer finds the UDF to be
displayed as:

="C:\Documents and Settings\Computer1User\Application
Data\Microsoft\AddIns\FarazTools.xlam!"UDFXYZ(arguments)

resuting into an error.

instead of simply

=UDFXYZ(arguments)

I have to always carryout the REPLACE method to replace

"C:\Documents and Settings\Computer1User\Application
Data\Microsoft\AddIns\FarazTools.xlam!"

with nothing.

What might be the reason and way out?

 

[Jacob Skaria]

Faraz, ask the user to save the add-In in Office\Library folder and from
Tools>Add-ins check (install) the Add-in. Now the user should be able to
access the UDFs directly