ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Uninstalling an add-in (https://www.excelbanter.com/excel-programming/288620-uninstalling-add.html)

Francisco José Tornay Mejías

Uninstalling an add-in
 
Hello to all,
I have written a macro for filtering a group of data based on the standard
deviation of different "segments" of the data.

Now I have written a little installation macro that automatically includes
my xla file as an addin and insert a menu command in the filter menu. I have
also written an uninstall macro that deletes the menu command.

Everything is working fine. The only problem is to uninstall the add-in. I
use the line that appears when I record the unchecking of my add-in, namely:

AddIns("Fil-Std").Installed = False

However, that doesn't seem to work properly. If, for instance, I uninstall
the macro, copy the xla file to a different directory and install it again.
I get a message error every time I open Excel stating that it can't find the
file in the old directory.

I have the same problem when I uncheck the add-in manually. It seems that
Excel (I use Office XP) records the location of the add-ins and unchecking
them doesn't erase it. On some occasions I have even got a message asking
whether I want to erase the add-in from the add-in list (as opposed to just
uncheck it) and I still got the error the next time I opened Excel.

My question is: How can I get Excel to forget about the add-in so I can
install it anew in a different directory?


Thank you in advance
Francisco Tornay




All times are GMT +1. The time now is 08:09 PM.

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