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

Free Support Forum - aspose.com

Can I get at a workbook's collection of code module using Aspose.Cells

In Excel VBA, I can edit a code module, assuming Tools/ Macro / Security / Trust Access to VB Projects is checked, by issuing a line like

With wbk.VBProject.Collection(0).VBComponents(4).CodeModule

to get at the 5th code module. I would like to dynamically edit it and eliminate code that may have been previously present in the VBA inside the open workbook. Possible?

Thanks in advance GUY


This message was posted using Page2Forum from Smart Markers - Aspose.Cells for .NET

Hi,

I am afraid, Aspose.Cells does not support this feature. I have logged your feature request into our issue tracking system with an id: CELLSNET-21312. We may look into it in future though after supporting VBA feature.

Thank you.