NativeExcel suite v2.x

Reference > IXLSWorkbook > VBAProject

VBAProject property

Returns an object that represents the VBA project in the specified workbook. Read-only TXLSVBAProject.

Syntax

property VBAProject: TXLSVBAProject;

Example

if WorkBook.VBAProject.Count > 0 then 
begin
  for i := 1 to WorkBook.VBAProject.Count do
  begin
    do_something(WorkBook.VBAProject[i].Name, WorkBook.VBAProject[i].SourceCode); 
  end;
end;

Copyright © NikaSoft 2004-2012