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!

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!

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!

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.