VbaModuleCollection

VbaModuleCollection class

Represents a collection of VbaModule objects.

public class VbaModuleCollection : ReadOnlyCollectionBase<VbaModule>

Properties

NameDescription
Count { get; }
Item { get; set; }

Methods

NameDescription
Add(VbaModule)
GetEnumerator()
ToList()

Examples

Shows how to iterate over VBA modules.

var project = new Project(DataDir + "VbaProject.mpp");
var vbaProject = project.VbaProject;

Console.WriteLine("Total Modules Count: " + vbaProject.Modules.Count);
foreach (var module in vbaProject.Modules)
{
    Console.WriteLine("Module Name: " + module.Name);
    Console.WriteLine("Source Code: " + module.SourceCode);
    Console.WriteLine();
}

// the collection can be converted into a plain list
List<VbaModule> modules = vbaProject.Modules.ToList();
foreach (var unused in modules)
{
    // work with modules
}

See Also