Command line switch to export VBA code, Macros, forms, etc. to a directory of text files from Word, Excel, Powerpoint and Access
Add command line switch to Office products to export VBA code, Macros, Form definitions, Table Schema, Worksheet properties, etc. to individual text files.
This is an export only and not an import.
1. I can full text search the VBA code base instead of the one at a time search interface in the VBA developer tools in Office.
2. I can commit the Word/Excel/Access file and the exported VBA source code to version control. This allows me to do differences and change tracking on the VBA code, table schemas, etc.
Some third party tools exist to do parts of this but they will surely be broken and unsupported in a few years.
My company has hundreds of specialty engineering computation Excel worksheets which we version control as Excel files but do not have insight into the VBA code, form code, etc. changes between versions.
Office 2016 and 2019 is what we use. We do not use Office 365.