MPPファイルからVBA情報を読み取ります

.NET APIのAspose.Tasksは、MPPファイルからVBA情報を読み取るためのサポートを提供します。これには、以下の作業が含まれます。

• VBA情報。

• プロジェクトに含まれるモジュール情報。

• リファレンスプロジェクトに保存されている情報。

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

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