Reading VBA Information from MPP file

Aspose.Tasks for .NET API provides support for reading VBA information from the MPP file. This includes working with:

• VBA Information.
• Modules information contained in the project.
• References Information stored in the project.

The VbaProject class is the main class for reading the VBA information from the project file. This further has Modules and References collection for reading further details of the VBA project file. This article demonstrates the usage of all these with the help of code samples.

Reading VBA Project Information

The following example shows how to read VBA Project Information with the help of VbaProject and Project class.

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 Information from VBA with the help of VbaProject, Project and VbaReference class

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 shows how to read modules information from VBA with the help of VbaProject, Project and IVbaModule class

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 modules attributes from VBA with the help of VbaProject, Project and IVbaModule class

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);