View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ric.payne@pcginternational.com is offline
external usenet poster
 
Posts: 3
Default Unload a COMaddin


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