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