Reading VBA Information from MPP File

Aspose.Tasks for .NET API provides full support for reading VBA information from Microsoft Project MPP files. This includes working with project-level VBA data, modules, references, and module attributes. The VbaProject class is the central point for accessing VBA details, while the Modules and References collections allow deeper inspection of the project contents.

Reading VBA Project Information

The following example shows how to read general VBA project information using the VbaProject and Project classes. This snippet demonstrates how to load a project file and access its associated VBA project data.

Project project = new Project("New Project.mpp");
VbaProject vbaProject = project.VbaProject;
Console.WriteLine("VbaProject.Name " + vbaProject.Name);
Console.WriteLine("VbaProject.Description " + vbaProject.Description);
Console.WriteLine("VbaProject.CompilationArguments " + vbaProject.CompilationArguments);
Console.WriteLine("VbaProject.HelpContextId " + vbaProject.HelpContextId);

Reading References Information from VBA

The following example shows how to read VBA references using the VbaProject, Project, and VbaReference classes. References contain external libraries or components that the VBA project depends on.

Project project = new Project("New Project.mpp");

VbaProject vbaProject = project.VbaProject;
VbaReferenceCollection references = vbaProject.References;
Console.WriteLine("Reference count ", references.Count);

VbaReference reference = vbaProject.References.ToList()[0];
Console.WriteLine("Identifier: " + reference.LibIdentifier);
Console.WriteLine("Name: " + reference.Name);

reference = vbaProject.References.ToList()[1];
Console.WriteLine("Identifier: " + reference.LibIdentifier);
Console.WriteLine("Name: " + reference.Name);

reference = vbaProject.References.ToList()[2];
Console.WriteLine("Identifier: " + reference.LibIdentifier);
Console.WriteLine("Name: " + reference.Name);

Reading Modules Information from VBA

The following example demonstrates how to read module information from VBA projects. Modules contain VBA code that defines macros, procedures, and functions. You can access each module and its associated details programmatically.

Project project = new Project("New Project.mpp");

VbaProject vbaProject = project.VbaProject;
Console.WriteLine("Total Modules Count: " + vbaProject.Modules.Count);

IVbaModule vbaModule = vbaProject.Modules.ToList()[0];
Console.WriteLine("Module Name: " + vbaModule.Name);
Console.WriteLine("Source Code: " + vbaModule.SourceCode);

Reading Module Attributes Information from VBA

The following example shows how to read module attributes using the VbaProject, Project, and IVbaModule classes. Attributes define additional properties of VBA modules such as descriptions, help context, or custom flags.

Project project = new Project("New Project.mpp");
VbaProject vbaProject = project.VbaProject;
IVbaModule vbaModule = vbaProject.Modules.ToList()[0];

Console.WriteLine("Attributes Count: " + vbaModule.Attributes.Count);
Console.WriteLine("VB_Name: " + vbaModule.Attributes.ToList()[0].Key);
Console.WriteLine("Module1: " + vbaModule.Attributes.ToList()[0].Value);

FAQ

Q: Do I need Microsoft Project installed to read VBA information?

• No. Aspose.Tasks for .NET can extract VBA data directly from MPP files without requiring Microsoft Project.

Q: Can I modify VBA code in MPP files using Aspose.Tasks for .NET?

• Currently, Aspose.Tasks for .NET allows reading VBA information, modules, and attributes, but it does not support editing VBA code.

Q: What type of VBA details can I extract from a project?

• You can read project-level VBA information, references to external libraries, modules containing code, and module-specific attributes.

Conclusion

Reading VBA information from Microsoft Project files with Aspose.Tasks for .NET is straightforward. You can programmatically access project-level VBA data, references, modules, and their attributes without Microsoft Project installed. This functionality is especially useful for auditing, reporting, or analyzing VBA-based automations within enterprise project files.