Unloading an Add-In

  • Thread starter Thread starter Jack
  • Start date Start date
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
 
Should be :-
AddIns.("XYZ").Installed = False

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