Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.
justhumm

justhumm

Structural
Joined
May 2, 2003
Messages
112
Location
US
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!

Capture01_pxct1m.png


Capture02_lkhnyz.png
 
Sort by date Sort by votes
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.

Code: 
 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.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

K
  • Locked
  • Question Question
How to create an add-in (VB Net) and add it to SolidWorks
Replies
1
Views
2K
MintJulep
M
Susangrizly
  • Locked
  • Question Question
How I circunavigated the problem with excel adding quotes to text
Replies
0
Views
799
Susangrizly
Susangrizly
William Heath
  • Locked
  • Question Question
change active cell in excel
Replies
4
Views
1K
IDS
IDS
C
  • Locked
  • Question Question
InserVariable is not recognised
Replies
2
Views
1K
Denial
Denial
yakpol
  • Locked
  • Question Question
UDF will not run in Excel 365
Replies
9
Views
1K
IDS
IDS

Part and Inventory Search

Sponsor

Back
Top