VBA 代码对象编程方法详解 一、前言 ...................................................................................................................................... 2 1.1 引用 VBA 扩展类库(Microsoft Visu al Basic For Applications Ex tensibility 5.3) . 2 1.2 需要启用编程方式访问 VBA 项目(仅在 EXCEL 中需设定) .............................. 2 二、VBA 的可扩展模型对象简介 ............................................................................................... 3 三、工程对象(Project) ........................................................................................................ 4 3.1 判断工程是否锁定 ........................................................................................................ 4 3.2 获得工程名 ................................................................................................................... 5 四、部件对象(VBComponent) ................................................................................................ 5 4.1 添加工程部件 ............................................................................................................... 5 4.2 移除工程中部件 ........................................................................................................... 6 4.3 列举部件名及类型信息 ............................................................................................... 7 4.4 判断部件是否存 ........................................................................................................... 8 4.5 导入部件文件添加部件 ............................................................................................... 8 4.6 导出部件为部件文件 ................................................................................................... 8 五、代码窗格对象(CodePane) .............................................................................................. 9 5.1 显示代码窗格 ...........................