Hello.-

Im trying to test excel capabilities to automate the analysis of excel
VBA development complexity, to perform this analysis we are thinking to use
the VBProject object, but to have access to VBA content in a workbook it
needs to set manually the Trust Acces to VBProjec Object option, due we are
thinking to work with around 2.000.000 excel workbooks this is not an option,
so Im looking for an alternative to automate this setting activation or
looking for new approaches to discover the VBA content of an excel workbook.

Our analysis process implies discover if a workbook have:

Modules
Function or Sub per Module
Line of Code per Function or Sub
Forms

I will appreciate any help about this topic.

Thanks