VbaModule Class

Provides access to VBA project module.

Inheritance Hierarchy

SystemObject
Aspose.WordsVbaModule

Namespace: Aspose.Words
Assembly: Aspose.Words (in Aspose.Words.dll) Version: 20.3

Syntax

C++

public class VbaModule

Public Class VbaModule

public ref class VbaModule

type VbaModule =  class end

The VbaModule type exposes the following members.

Constructors

	Name	Description
	VbaModule	Creates an empty module.

Properties

	Name	Description
	Name	Gets or sets VBA project module name.
	SourceCode	Gets or sets VBA project module source code.
	Type	Specifies whether the module is a procedural module, document module, class module, or designer module.

Methods

	Name	Description
	Clone	Performs a copy of the VbaModule.
	Equals	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	ToString	(Inherited from Object.)

Examples

Shows how to get access to VBA project information in the document.

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

// A VBA project inside the document is defined as 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;
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 retrieve object by integer or by name
vbaModules[0].SourceCode = "Your VBA code...";
vbaModules["Module1"].SourceCode = "Your VBA code...";

// Remove one of VbaModule from VbaModuleCollection
vbaModules.Remove(vbaModules[2]);

Reference

Aspose.Words Namespace