How do I update an Add-in
How do I update an Add-in
(OP)
I have made an add-in for Excel with functions specific to our company. I am updating this add-in on a weekly basis. I am currently going to each workstation to copy the new version to the add-in folder.
How can I have the add-in automatically update for each work station?
Can I store the add-in on the server?
Can I move the default location for add-ins?
Any suggestions are appreciated (especially the convoluted or bizarre).
How can I have the add-in automatically update for each work station?
Can I store the add-in on the server?
Can I move the default location for add-ins?
Any suggestions are appreciated (especially the convoluted or bizarre).





RE: How do I update an Add-in
HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options\ (replace the 9.0 by your Office version, probably 11.0) in the entries named OPEN= , OPEN1=, etc.
Alternatively, you can set the alternate startup file location to some place on your network. That will allow you to add new add-ins as you develop them. This is specified under Tools/Options/General.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: How do I update an Add-in
I had gone through that process before but I did not click "No". I didn't know that it was that simple.
RE: How do I update an Add-in
RE: How do I update an Add-in
It was successful even though 2 other people are using Excel with the add-in active.
We are running Excel version 11.
RE: How do I update an Add-in
Brad.
RE: How do I update an Add-in
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: How do I update an Add-in