sub iterateProjects() dim projs as vbProjects dim proj as vbProject dim refs as References dim ref as Reference dim comps as vbComponents dim comp as vbComponent dim i as integer dim r as integer dim c as integer set projs = application.VBE.vbProjects for i = 1 to projs.Count set proj = projs(i) debug.print "Project: " & proj.Name ' default: "VBAProject" debug.print " description: " & proj.description debug.print " buildFileName: " & proj.buildFileName debug.print " mode: " & proj.mode set refs = proj.References debug.print "" debug.print " References" for r = 1 to refs.Count set ref = refs(r) debug.print " Reference: " & ref.Name debug.print " Guid: " & ref.GUID debug.print " path: " & ref.fullPath debug.print " version: " & ref.major & "." & ref.minor debug.print " type: " & ref.type next r debug.print " Components" set comps = proj.VBComponents for c = 1 to comps.Count set comp = comps(c) debug.print " Component: " & comp.name debug.print " type: " & comp.type debug.print " code module: " & comp.codeModule next c next i end sub