Checking if a public module exists in the database

[zevw]

I would like to check if the module "ProgUpdt" exists in the database. and if not import that module from a different database.

I know how to do it for Queries, but not for modules.

Dim AllQueries As QueryDef
Dim QueryName As String

    For Each AllQueries In CurrentDb.QueryDefs
        
        QueryName = AllQueries.Name
        If QueryName = "Import Query" Then
            DoCmd.DeleteObject acQuery, QueryName
        End If
    Next AllQueries

 

[Remou]

How about:

For Each mdl In CurrentProject.AllModules
Debug.Print mdl.Name
Next