We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Adding/removing references to VBA addins

I am considering using the Aspose.Cells for server-side Excel spreadsheet generation.

Is there any way I can change the path to the referenced addin using your API?

Our spreadsheet applications use number for custom developed xla addins, which are referenced in the VBA. Normally this is done via Microsoft Visual Basic/Tools/References and referenced addins can be seen in the Project pane under References folder.

Thank you.

Hi,

Please try to utililize Cell.SetAddInFormula(string addInFileName, string addInFunction) method to set addin formulas (.xla files) for your requirement. And If you want to change the code in VBA codes directly, we do not support to manipulate VBA \ macros although we keep vba/macros with the template file and save/save as with it.

Thank you.