Get 2007 Add-in Path

[chris]

Hi,

how can I retrieve the path a 2007 add-in is located ?

Thanks a lot in advance.

 

[John Wilson]

I think this should do it

Sub addinpath()
Dim i As Integer
Dim strpath As String
For i = 1 To AddIns.Count
strpath = strpath + AddIns(i).Name & " is at " & AddIns(i).Path & vbCrLf
Next i
MsgBox strpath
End Sub

(to use in case you don't know)

alt f11 to open vb editor
Insert module
paste in the code and f5