HotXLS Docs
Contents
Home
Overview
IXLSWorkbook
Home
Contents
IXLSWorkbook
ClearVBAProject method
Removes the workbook's preserved classic XLS VBA storage payload and any parsed
VBAProject
view created from it. The method is an alias for
ClearVBA
with naming that matches the other VBA project payload helpers.
Syntax
procedure
ClearVBAProject;
Example
Workbook.ClearVBAProject; Workbook.SaveAs(
'C:\Reports\NoMacros.xls'
, xlExcel97);
See also
IXLSWorkbook.HasVBAProject method
IXLSWorkbook.VBAProject property
IXLSWorkbook.SaveVBAProjectToFile method