能否通过VBA修改其他VBA代码？求相关对象/集合名称指引

Great question—yes, you absolutely can modify VBA code programmatically using VBA itself! Here are the key objects and collections you’ll want to look up in Microsoft’s official docs to get started:

• VBProject: The top-level object representing an entire VBA project (e.g., the VBA project inside an Excel workbook, Word document, etc.). It acts as the container for all your VBA components.
• VBComponents: A collection under VBProject that holds all individual components in the project—think standard modules, class modules, user forms, and even the code modules attached to worksheets or workbooks.
• VBComponent: Represents a single component within the VBComponents collection. Each component has an associated code module you can interact with.
• CodeModule: The object tied to a VBComponent that lets you read, edit, add, or delete lines of VBA code. This is where you’ll perform the actual code modifications.

A quick heads-up: You’ll need to enable trust access to the VBA project object model in your Office app’s macro security settings to use these objects, but that’s a one-time configuration step.

内容的提问来源于stack exchange，提问作者JimG