NativeExcel for .Net Developer's Reference

IWorkbook.ClearVBA Method 

Removes preserved VBA block from the workbook.

[Visual Basic]
Sub ClearVBA()
[C#]
void ClearVBA();
[C++]
void ClearVBA();
[JScript]
function ClearVBA();

Example

This example removes VBA block from the modified workbook.

[C#]
IWorkbook book = Factory.OpenWorkbook("book.xls");
if (book != null) {
   book.ClearVBA();
   book.SaveAs("book2.xls");  
} 

See Also

IWorkbook Interface | NativeExcel Namespace