Sharing XLAM Add-In with other users...?
Sharing XLAM Add-In with other users...?
(OP)
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!
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!
Talk To Other Members
RE: Sharing XLAM Add-In with other users...?
CODE -->
Set AI = Application.AddIns.Add(filename:=network_install_path, copyfile:=False) AI.Installed = Truethe 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