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

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

Hi,
You may want to take a look at 'addinloader' by Charles Williams'
Decision Models. Works fine for me.

http://www.decisionmodels.com/Downloads/AddLoaderV2.zip

Regards,
Poniente





On 29 jul, 06:39, avi wrote:
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

Poniente formulated the question :
Hi,
You may want to take a look at 'addinloader' by Charles Williams'
Decision Models. Works fine for me.

http://www.decisionmodels.com/Downloads/AddLoaderV2.zip

Nice utility! I clearly see where this would be beneficial in a
corporate environment.

Not sure, though, that it offers much more than what's doable via the
Addins Manager dialog. Ok, the list of addins 'allowed' is one way to
control which ones users can load, but a simple open password would
service the same need in most cases.

Still, I do like the concept! Very nicely done...!

--
Garry

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

I'd recommend the Addin loader from Decision models.
I have a version adapted for Xl2007/10 which I can email to you.

On 1 août, 09:12, minimaster
wrote:
I'd recommend the Addin loader from Decision models.
I have a version adapted for Xl2007/10 which I can email to you.

Thanks to all of you

Very promising

Avi