Hi
Could anyone help me determine what workbook a VBProject belongs to please?

I've commented out Workbook.Name: that property doesn't exist but demonstrates what I want to find:

With Application.VBE.VBProjects
    For x = 1 To .Count
        MsgBox Application.VBE.VBProjects(x) '.Workbook.Name
    Next x
End With
I know I can loop through the workbooks collection but I'm trying to get a list of all the installed addins. The workbook collection ignores addins.

If I loop throught the Addins collection instead, testing the Installed property, it takes several seconds to finish the small loop: a noticable delay to my end users.

Looping through the VBProjects seems the fastest way to check ALL open workbooks, whether an add-in or not.

Anyone able to help?

Thanks,
Sam