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, adds a new VBA module and macro code, and saves the output in the XLSM format. Once you 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, the following macro code.

 Sub ShowMessage()

    MsgBox "Welcome to Aspose!"

End Sub

Sample Code

Here is sample code to generate the output XLSM file with a VBA module and macro code.