avi laid this down on his screen :
Hello,

I'm looking for some Robust Excel addin installation(and
uninstallation) through vba code or approach

All the approaches until now seem to present some problem

Best regards
Avi

What are you trying to accomplish? If simply looking for a way to
load/unload an addin that is not a member of the addins collection then
the Open/Close methods of the workbooks collection should suffice.
Otherwise, the Installed property of the addins collection can be
toggle True/False if the addin is already a member of the collection.

If you're trying to figure out how to distribute an addin so it's
automagically installed on the remote machine then you need to query
Registry keys and write appropriate keys for each installed version of
Excel. An installation app can do this no problem.

I have VB6 code that removes installed addins and the files belonging
to them (works like Remove Program in Control Panel) that I suppose
could also be configured to install addins, but I'm not sure about that
as I've never tried because I use a installation app.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc