Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

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?


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

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.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close