Is there any way to use VBA to programatically unload or at least
change the load behavior of a COM Addin?

To unload a COM add-in :
AddIns("Analysis ToolPak").Installed = False

You cannot change its behavior because it is compiled. You would hav
to change the source code and recompile it

--
raypayett

-----------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...fo&userid=2956
View this thread: http://www.excelforum.com/showthread.php?threadid=57051

maybe you can use something like:

Option Explicit
Sub testme()
Dim iCtr As Long

With Application.COMAddIns
For iCtr = 1 To .Count
With .Item(iCtr)
MsgBox .Description & vbLf & .progID & vbLF & .GUID
End With
Next iCtr
End With
End Sub

To find the name of the COM Addin you want and then turn it off with:

Application.COMAddIns(whateverprogidyouneed).Conne ct = False

wrote:

Is there any way to use VBA to programatically unload or at least
change the load behavior of a COM Addin?

--

Dave Peterson

Dave Peterson wrote:
maybe you can use something like:

Option Explicit
Sub testme()
Dim iCtr As Long

With Application.COMAddIns
For iCtr = 1 To .Count
With .Item(iCtr)
MsgBox .Description & vbLf & .progID & vbLF & .GUID
End With
Next iCtr
End With
End Sub

To find the name of the COM Addin you want and then turn it off with:

Application.COMAddIns(whateverprogidyouneed).Conne ct = False

wrote:

Is there any way to use VBA to programatically unload or at least
change the load behavior of a COM Addin?

--

Dave Peterson

Dave Peterson wrote:
maybe you can use something like:

Option Explicit
Sub testme()
Dim iCtr As Long

With Application.COMAddIns
For iCtr = 1 To .Count
With .Item(iCtr)
MsgBox .Description & vbLf & .progID & vbLF & .GUID
End With
Next iCtr
End With
End Sub

To find the name of the COM Addin you want and then turn it off with:

Application.COMAddIns(whateverprogidyouneed).Conne ct = False

wrote:

Is there any way to use VBA to programatically unload or at least
change the load behavior of a COM Addin?

--

Dave Peterson

Thanks Dave. That's exactly what I was looking for.

Ric