Iterate Code Modules

pootle flump · #1 (**permalink**) 10-28-09, 05:58

Hi

In Access there is a Modules container and Module objects that can be iterated, read from and written to. Doesn't seem so in Excel - is this correct please?

Thanks

Colin Legg · #2 (**permalink**) 10-28-09, 06:20

Hi,

I don't use this part of the object model very often....

A CodeModule belongs to a VBComponent object which can be referenced via the VBComponents object collection. For early binding a reference to the Microsoft VBA Extensibility library is required:

Code:

Sub foo()

    Dim vbc As VBIDE.VBComponent
    
    For Each vbc In ThisWorkbook.VBProject.VBComponents
        Debug.Print vbc.Name
        'vbc.CodeModule....
    Next vbc
    
End Sub