Sharing XLAM Add-In with other users...?

[justhumm]

I am not too familiar with Excel add-ins, but I have a simple XLAM add-in that has a few different User Defined Functions (UDFs).

I've shared this XLAM with a few people. And, when they open up a workbook where I inserted a UDF, even when they have the add-in installed and activated, Excel is inserting a path to the add-in directory on my computer.

Just out of curiosity, why is Excel inserting a filepath to the original user's add-in folder, as opposed to just realizing that the UDF is defined in Excel's default UDF folder?

And, what I'm more interested in learning, is there some sort of workaround for this, so that Excel stops inserting the file path when multiple users are working with the UDF-containing file?

Thanks!

 

[Agent666]

I get around this by storing the addin on the network, and set it to read only (this is important if multiple people are accessing it. Then when you install the addin the first time there is an option if using VBA to install/enable it to leave it on the network and reference that location.

 Set AI = Application.AddIns.Add(filename:=network_install_path, copyfile:=False)
            AI.Installed = True

the copyfile:=false leaves the file on the network path, otherwise it will copy it to the local users addin folder path. Post back if you cannot get it working, sometimes once you've already installed the addin it can be a bit hard to delete it and reinstall using this method.

The issue is when fred uses a spreadsheet the path to the addin is hardcoded to his path to the addin, so when Joe uses the same spreadsheet, it cannot find the path because its looking under Freds path. You can however manully update the path using edit links under DATA tab, just update the 'source' to your path.

https://engineervsheep.com