ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Add-In problem (https://www.excelbanter.com/excel-discussion-misc-queries/137070-add-problem.html)

Barb Reinhardt

Add-In problem
 
I received an add-in to modify thats used in conjunction with another
workbook. When I send the workbook/add-in combination to the individuals
who need to use it, all of the references to the User Defined functions in
the add-in now include a link to where the add-in was saved on my system. I
don't want to have to tell them to take out the path name each time it's sent
to a new person. What needs to be done to fix this?

Thanks,
Barb Reinhardt

Dave Peterson

Add-In problem
 
You could tell tell them to open the file and fix the links:

Edit|links|Change source
to point at the new location.

But if you want to be nice, you may want to try this:
Create a new folder on your harddrive (C:)
call it: C:\BarbsUtils
Put your addin in that location.

Then when you share the addin with the other folks, tell them to put the addin
in that same location on their system (C:\barbsutils)

And then they could use Tools|Addins (and browse for that addin) to install your
addin.



Barb Reinhardt wrote:

I received an add-in to modify thats used in conjunction with another
workbook. When I send the workbook/add-in combination to the individuals
who need to use it, all of the references to the User Defined functions in
the add-in now include a link to where the add-in was saved on my system. I
don't want to have to tell them to take out the path name each time it's sent
to a new person. What needs to be done to fix this?

Thanks,
Barb Reinhardt


--

Dave Peterson


All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com