Adding VBA Module and Code using Aspose.Cells
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.