Distribute Addin

[Libby]

Hi there,

I've created an Addin which contains custom forms for routine, but complex
things i do. Other people have expressed an interest in having them, but I'm
not sure what is the best way to get the addin from my Addins folder to their
Addins folder.

We have a "menu" type workbook from which it might be possible to have a
download feature which could copy it from a stored location to their Addins
folder, but it'd need to overwrite the existing file.

Any ideas?

Cheers
x

 

[Dave Peterson]

Do you have a common network drive that can hold the addin?

If yes, then I'd put the addin in that location. Then tell the users to use
Tools|Addins to browse for that addin in that common network location. In fact,
I'd tell them to use the UNC Path instead of any mapped drive letter.

If that's not possible, then I'd tell the users to create a new folder on their
C: drive. Name that new folder:

C:\LibbyUtils

And then just email the addin to them with instructions to save the file into
that special folder C:\LibbyUtils.

Then tell them to use Tools|Addins to install the addin.

(All of this assumes that you're using xl2003 menus.)

By storing the addin in a folder with the same name, you'll be avoiding lots of
problems of where the macros are.

 

[john]

Libby,
have a look at this article - may be of some help to you.
http://www.vbaexpress.com/forum/showthread.php?t=10855&garpg=5

 

[Peter T]

It's an interesting article and written with good intent. However, at a
glance, some aspects of the code are incorrect or incomplete and may
potentially lead to various errors (break) and failure to install as an
addin into the addin manager.

Another link here
http://www.jkp-ads.com/articles/DistributeMacro10.htm
and other articles on the same site

Regards,
Peter T

 

[Libby]

Thanks Peter. It works a treat.

It's an interesting article and written with good intent. However, at a
glance, some aspects of the code are incorrect or incomplete and may
potentially lead to various errors (break) and failure to install as an
addin into the addin manager.

Another link here
http://www.jkp-ads.com/articles/DistributeMacro10.htm
and other articles on the same site

Regards,
Peter T