Missing adding - How to tell where it is pointing to?

[Chrissirhc]

Hi,

I have a missing addin. How do I tell which location it is trying to find it (The dialogue width is not big enough for me to see where it is pointing to)

Thanks,

Chris

 

[TonyJollans]

You don't say which application or which version. In recent versions, certainly, the dialog should be resizeable.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[Chrissirhc]

Fair point. For some reason I automatically assume this forum is Excel VBA forum... Sorry.

Excel 2002

 

[Chrissirhc]

Any ideas? Thanks, Chris

 

[PHV]

Maybe this little sub may help you:
Sub ListAddIns()
Dim i As Integer
For i = 1 To Application.AddIns.Count
With Application.AddIns(i)
Debug.Print .FullName, .Installed
End With
Next
End Sub

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886