Get 2007 Add-in Path

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Hi,

how can I retrieve the path a 2007 add-in is located ?
Click to expand...

John's given you a way to list addins and the path for each.

If you know the name of the addin and need to retrieve it in code:

Assuming you've stashed the name of the addin in a variable named sAddinName:

MsgBox Application.Addins(sAddInName).Path
 
Back
Top