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
|