Adding VBA Module and Code using Aspose.Cells

Aspose.Cells allows you to add a new VBA Module and Macro Code using Aspose.Cells. Please use the Workbook.getVbaProject().getModules().add() method to add the new VBA Module inside the workbook

Adding VBA Module and Code using Aspose.Cells

The following sample code creates a new workbook and adds a new VBA Module and Macro Code and saves the output in the XLSM format. Once, you will open the output XLSM file in Microsoft Excel and click the Developer > Visual Basic menu commands, you will see a module named “TestModule” and inside it, you will see the following macro code.

 Sub ShowMessage()

    MsgBox "Welcome to Aspose!"

End Sub

Sample Code

Here is a sample code to generate the output XLSM file with VBA Module and Macro Code.

Add a library reference to VBA project in workbook Check if VBA Code is Signed