Unloading an Add-In

J

Jack

Hello,

I wonder if anyone has run into the stange problem I encountered.

I'm writing a simple install program that installs XYZ.XLA. If the XLA is
loaded, I need to uninstall it first, otherwise the FileCopy will fail.

When the following line executes to unload XYZ.XLA:
AddIns.item("XYZ").Installed = False

Excel just stops executing my code. I've tried various On Error combinations
without any success.

Has anyone dealt with this problem before?

Thanks,

Jack
 
B

BrianB

Should be :-
AddIns.("XYZ").Installed = False

Regards
BrianB
==========================================
 
Top