This article guides on how to modify Excel VBA library using C#. It shares the IDE settings, a list of steps and a code snippet to add module in an Excel VBA code library using C#. It demonstrates accessing the VBA project and adding modules and code in the workbook.

Steps to Modify Excel VBA Code Library using C#

1. Set the IDE to use Aspose.Cells for .NET to add module and code
2. Create a workbook, access a sheet, and add a VBA module
3. Access the newly created module using the new module index
4. Set the name and code for the module
5. Save the output Excel file with the new VBA macro

These steps explain the process to add module in Excel VBA source code library using C#. Access the VbaProject.Modules collection of the selected workbook and call the Add() method to add a new module. Get a reference to the newly created module and set its name and Codes to the desired values before saving the resultant XLSM file.

Code to Update Excel Macro Library using C#

This sample code demonstrates how to access VBA code library using C# in an Excel file and add module and code. The sample code in the module displays a message box in MS Excel whenever the cell A1 value is changed. This message box contains the updated value in the cell, however, you may change the code according to your requirements.

This article has taught us to add macros to an Excel file. To show formulas in Excel, refer to the article on how to show formulas in Excel using C#.