How to get VBProject Workbook Name

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:

Please Login or Register  to view this content.

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

Thanks Xlbiznes, but that's not quite what I'm after. I want to get the workbook names of ALL the open VBProjects within the current Excel Application, not just ThisWorkbook or ActiveWorkbook.

Once I've got ALL the workbooks I can test their IsAddIn properties to continue my program.

Maybe this can help!

Please Login or Register  to view this content.

Gerard

OK thanks xlbiznes - you've prodded me towards the solution.
I've realised I wasn't clear enough when detailing what I was after in my original post. I wanted to get the workbook name of every VB Project currently open, whether an add-in or not. The workbooks collection ignores add-ins, so no use. Looping through the add-ins collection takes a noticably long time, so no use.

The solution was to loop through the VB Projects and exract the workbook name from the Filename property. This tests all workbooks, whether add-in or not, and also loops quickly. Problem solved.

Please Login or Register  to view this content.