View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
BrianB BrianB is offline
external usenet poster
 
Posts: 109
Default Unloading an Add-In

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

Regards
BrianB
==========================================


"Jack" wrote in message news:<Etneb.8937$Rd4.6890@fed1read07...
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