VbaProject Class

Provides access to VBA project information. A VBA project inside the document is defined as a collection of VBA modules.

Inheritance Hierarchy

SystemObject
Aspose.Words.VbaVbaProject

Namespace: Aspose.Words.Vba
Assembly: Aspose.Words (in Aspose.Words.dll) Version: 22.5.0

Syntax

C++

public class VbaProject

Public Class VbaProject

public ref class VbaProject

type VbaProject =  class end

The VbaProject type exposes the following members.

Constructors

	Name	Description
	VbaProject	Creates a blank VbaProject.

Properties

	Name	Description
	CodePage	Returns the VBA project’s code page.
	IsSigned	Shows whether the VbaProject is signed or not.
	Modules	Returns collection of VBA project modules.
	Name	Gets or sets VBA project name.
	References	Gets a collection of VBA project references.

Methods

	Name	Description
	Clone	Performs a copy of the VbaProject.
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object.)
	GetHashCode	Serves as the default hash function. (Inherited from Object.)
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	ToString	Returns a string that represents the current object. (Inherited from Object.)

Examples

Shows how to access a document's VBA project information.

Document doc = new Document(MyDir + "VBA project.docm");

// A VBA project contains a collection of VBA modules.
VbaProject vbaProject = doc.VbaProject;
Console.WriteLine(vbaProject.IsSigned
    ? $"Project name: {vbaProject.Name} signed; Project code page: {vbaProject.CodePage}; Modules count: {vbaProject.Modules.Count()}\n"
    : $"Project name: {vbaProject.Name} not signed; Project code page: {vbaProject.CodePage}; Modules count: {vbaProject.Modules.Count()}\n");

VbaModuleCollection vbaModules = doc.VbaProject.Modules; 

Assert.AreEqual(vbaModules.Count(), 3);

foreach (VbaModule module in vbaModules)
    Console.WriteLine($"Module name: {module.Name};\nModule code:\n{module.SourceCode}\n");

// Set new source code for VBA module. You can access VBA modules in the collection either by index or by name.
vbaModules[0].SourceCode = "Your VBA code...";
vbaModules["Module1"].SourceCode = "Your VBA code...";

// Remove a module from the collection.
vbaModules.Remove(vbaModules[2]);