Add a library reference to a VBA project in a workbook

Sometimes, you need to add or register the library reference to the VBA project through code. You can do it using Aspose.Cells VbaProject.References.AddRegisteredReference() method.

Add a library reference to VBA project in Microsoft Excel

In Microsoft Excel, you can add a library reference to the VBA project by clicking Tools > References… manually.

Add a library reference to the VBA project in a workbook using Aspose.Cells

The following sample code adds or registers two library references to the workbook’s VBA project using the VbaProject.References.AddRegisteredReference() method.