ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XLA Unload problem (https://www.excelbanter.com/excel-programming/287484-xla-unload-problem.html)

Von Shean

XLA Unload problem
 
I have to unload my XLA under some circumstances. I have tried the following
two ways.
1. MyXLA.Close
2. Application.AddIns("MyXLA").Installed = False

Both of these close the XLA but fail uncheck the Add-in checkbox in
Tools=Add-in meni

Does anyone have a way to uncheck the add-in check box for an XLA who wants
to unload itself??




Rob van Gelder[_4_]

XLA Unload problem
 

This works for me (for my Analysis Toolpack addin)
Application.AddIns(2).Installed = False

Rob

"Von Shean" wrote in message
...
I have to unload my XLA under some circumstances. I have tried the

following
two ways.
1. MyXLA.Close
2. Application.AddIns("MyXLA").Installed = False

Both of these close the XLA but fail uncheck the Add-in checkbox in
Tools=Add-in meni

Does anyone have a way to uncheck the add-in check box for an XLA who

wants
to unload itself??







All times are GMT +1. The time now is 07:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com