Working with VBA Macros

Overview

Visual Basic for Applications (VBA) for Microsoft Word is a simple but powerful programming language that can be used to extend the functionality. Aspose.Words API provides three classes to get access to the VBA project source code:

  • The VBAProject class provides access to the VBA project information
  • The VBAModulesCollection class returns the collection of VBA project modules
  • The VbaModule class provides access to the VBA project module

Creating a VBA Project

Aspose.Words API provides the Dcoument.VbaProject property to get or set VbaProject in the document. The following code example demonstrates how to create a VBA project and VBA Module along with basic properties e.g. Name and Type. 

Read Macros

The following code example demonstrates how to read VBA Macros from the document.

Modify Macros

The following code example demonstrates how to modify VBA Macros from the document using the VbaModule.setSourceCode() property.

Clone VBA Project

 The following code example demonstrates how to clone the VBA Project using the VbaProject.Clone property which creates a copy of the existing project. 

Clone VBA Module

 The following code example demonstrates how to clone the VBA Module using the VbaModule.Clone property which creates a copy of the existing project.