unload an add-in from an Macro
 

sure we can enable a macro by click tools=add-ins=click addin name an
ok
But does any Excel expert here knows how can I unload the add-ins fro
a vba macro?
Thanks :cool

--
lang047
-----------------------------------------------------------------------
lang0477's Profile: http://www.excelforum.com/member.php...fo&userid=2397
View this thread: http://www.excelforum.com/showthread.php?threadid=37597

unload an add-in from an Macro
 

From help on the Installed property of the addin object:

Set a = AddIns("Solver Add-In")
If a.Installed = True Then
MsgBox "The Solver add-in is installed"
Else
MsgBox "The Solver add-in is not installed"
End If

so set the installed property to false

--
Regards,
Tom Ogilvy


"lang0477" wrote in
message ...

sure we can enable a macro by click tools=add-ins=click addin name and
ok
But does any Excel expert here knows how can I unload the add-ins from
a vba macro?
Thanks :cool:


--
lang0477
------------------------------------------------------------------------
lang0477's Profile:
http://www.excelforum.com/member.php...o&userid=23975
View this thread: http://www.excelforum.com/showthread...hreadid=375972

unload an add-in from an Macro
 

addins("myAddin").installed=false

--
HTH

Bob Phillips

"lang0477" wrote in
message ...

sure we can enable a macro by click tools=add-ins=click addin name and
ok
But does any Excel expert here knows how can I unload the add-ins from
a vba macro?
Thanks :cool:


--
lang0477
------------------------------------------------------------------------
lang0477's Profile:
http://www.excelforum.com/member.php...o&userid=23975
View this thread: http://www.excelforum.com/showthread...hreadid=375972

unload an add-in from an Macro
 

Good afternoon lang0477

This should do the trick:

Sub Remove_Add-In()
On Error Resume Next
AddIns("MyAdd-In").Installed = False
End Sub

Short and sweet.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=375972

unload an add-in from an Macro
 

excellent, thanks guys :

--
lang047
-----------------------------------------------------------------------
lang0477's Profile: http://www.excelforum.com/member.php...fo&userid=2397
View this thread: http://www.excelforum.com/showthread.php?threadid=37597