Unloading an Add-In
 

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

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