The following code shows how to refresh the Procedures collection of a Catalog. This is required before Procedure objects from the Catalog can be accessed.
Attribute VB_Name = "ProceduresRefresh"
Catalog Object | Procedures Collection | Refresh Method