UNLOAD ADD-INS utility?

[Jen]

Hello there,

It is somehow a bit painfull to unload add-ins IMO. Has someone written an
add-in that shows the "loaded" add-ins and where you can "uncheck" them to
unload them?
Jen

 

[Chip Pearson]

Doesn't the standard "Add-Ins" dialog on the Tools menu suffice? It lists
all add-ins known to Excel and indicates which are loaded. You can unload an
add-in simply by unchecking its box in the dialog.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Jen]

Hi Chip,

The standard "Add-ins" in the Tools menu do not show the add-ins which you
do not call via the "Browse" no?
ie. If I "load" an add-in just by double clicking on the file. That add-in
does not show in the Tools>Add-ins, but it does -luckily- show in the VBE
Project explorer.
There are a couple add-ins which I tend to load all the time ...and those I
can unload via the Tool>Add-ins-menu. But the less common add-ins I just
open "for the occasion" by double clicking them. I therefore would love to
have the possibility to unload them in a flexible way ... not to
"over-charge" the excel application.

Is it the best way to "register" each and every single add-in ...and then go
the Tools>Add-ins way?
Jen

 

[Dave Peterson]

When I want to close an addin (or any hidden workbook), I'll just open the VBE,
hit ctrl-g to see the immediate window and type something like:

workbooks("youraddinname.xla").close savechanges:=false

and hit enter

 

[Jen]

Hi Dave,
Yes that's what I do at the moment ...
In the immediate window:
?Thisworkbook.Name
(to make sure I've the right add-in)
and tehn
Thisworkbook.Close

But I find it a bit cumbersome.
Well... I've only discovered VBA recently and think that everything can be
done via VBA..and that plenty has already been done before. But maybe I'll
make have to make it a project to try to write myself an add-in for this
purpose

It promises a lot of NG-postings
Jen

 

[shah shailesh]

Hi Jen,

You may download one Addins "Workbook Navigation" from Addins page of below
site which has option to close addins.

http://in.geocities.com/shahshaileshs/


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.

 

[Jen]

Hi Shah,

I downloaded your add-in ... but I've a problem figuring out on how I
possibly could close an add-in...
Nice colors
Jen

 

[Jen]

Hi Shah,

I figured out now on how your add-in works! It wasn't that difficult, one
should just know that you can right-click on your buttons!
I knew someone must have written an add-in to unload installed add-in....
and yours does so much more too!
Cool work! And thanks for sharing it!

Jen

 

[shah shailesh]

Hi Jen,

Glad to know you liked it.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.