Excel VBA add-in portability
I have an Excel addin (.XLA file) that contains some custom functions. My problem:
1. User 1 has the xla file saved in the C:\ directory.
2. User 2 has the xla file saved in the c:\program files\ directory (or any other directory that is different from User 1).
3. User 1 creates a workbook that uses the custom addin functions.
4. User 2 opens the workbook, and gets the 'Update Links' prompt, even though he has the addin open and running. Excel looks for the addin in User 1's directory, and inserts a full filepath in the calls to the custom function.
Is there any way to prevent Excel from assuming the full file path to the addin when functions are called from a worksheet? Or is the best way to get everyone to save the addin in the same place? Thanks!