Modifying VBA or Macro Code using Aspose.Cells

You can modify VBA or macro code using Aspose.Cells. Aspose.Cells has added the following classes to read and modify the VBA project in the Excel file.

• VbaProject
• VbaModuleCollection
• VbaModule

This article will show you how to change the VBA or macro code inside the source Excel file using Aspose.Cells.

Example

The following sample code loads the source Excel file which has the following VBA or macro code inside it

 Sub Button1_Click()

MsgBox "This is test message."

End Sub

After executing the Aspose.Cells sample code, the VBA or macro code will be modified as follows

 Sub Button1_Click()

MsgBox "This is Aspose.Cells message."

End Sub

You can download the source Excel file and the output Excel file from the given links.