Best Way To Install Add-Ins
 

Hi all,

Can someone tell me the best way to install an add-in? Preferably
without having to open a separate workbook...

Thanks in advance!

Best Way To Install Add-Ins
 

You may have your terminology confused.

To install an existing add-in:

AddIns("MyAddIn").Installed = True

If you want to use your own add-in, it has to be a separate workbook.

--

Vasant




"spIky haIred" wrote in message
oups.com...
Hi all,

Can someone tell me the best way to install an add-in? Preferably
without having to open a separate workbook...

Thanks in advance!

Best Way To Install Add-Ins
 

If you want to automate it, that is you don't want the user to do Tools,
Add-ins etc.
then I think your best bet is to use something like INNO installer.
To make it foolproof is very difficult though. I have been working on this
for the last few
months and I think I am getting close now to a foolproof install.
One of the most difficult bits is dealing with previous Office versions,
especially if these
previous versions are a higher version than the current one.
If you want I can post my INNO script here.

RBS

"spIky haIred" wrote in message
oups.com...
Hi all,

Can someone tell me the best way to install an add-in? Preferably
without having to open a separate workbook...

Thanks in advance!

Best Way To Install Add-Ins
 

RB Smissaert - I would be interested in the script you've worked on for the
Excel install...I am trying to figure out how to deploy a custom
toolbar/macro to un-savvy users in the easiest way possible, and I think your
suggestion of INNO Installer might do the trick. They are on multiple
platforms so any help you can provide would help speed up my work. If you'd
rather do this via email hit me at spamcatcher.jlk(at)gmail.com. Thanks.