Robust Excel addin installation through vba

[avi]

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

 

[GS]

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.

 

[Poniente]

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

 

[GS]

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...!

 

[minimaster]

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

 

[avi]

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