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

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.

Libby wrote:
>
> 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

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


"Libby" wrote:

> 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

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



"john" <(E-Mail Removed)> wrote in message
news:59EF2CE2-5BAC-4FBF-9E16-(E-Mail Removed)...
> Libby,
> have a look at this article - may be of some help to you.
> http://www.vbaexpress.com/forum/show...=10855&garpg=5
> --
> JB
>
>
> "Libby" wrote:
>
> > 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

Thanks Peter. It works a treat.

"Peter T" wrote:

> 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
>
>
>
> "john" <(E-Mail Removed)> wrote in message
> news:59EF2CE2-5BAC-4FBF-9E16-(E-Mail Removed)...
> > Libby,
> > have a look at this article - may be of some help to you.
> > http://www.vbaexpress.com/forum/show...=10855&garpg=5
> > --
> > JB
> >
> >
> > "Libby" wrote:
> >
> > > 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
>
>
>