利用VBA快速开发能效测评技术文件收集系统的研究  

Research on Rapid Development of Technical Document Collection System for Energy Efficiency Evaluation with VBA

作　　者：蔡航 李振全[1] 雷亚平 CAI Hang;LI Zhenquan;LEI Yaping(Suzhou Institute of Building Science Research Group Company Limited)

机构地区：[1]苏州市建筑科学研究院集团股份有限公司

出　　处：《上海节能》2022年第4期487-492,共6页Shanghai Energy Saving

摘　　要：能效测评是综合判定建筑物节能量的评价方法,技术文件收集阶段作为能效测评最先开展的工作,也是最耗时的阶段。利用VBA易获取以及快速开发用户交互界面的特性,编写技术文件收集系统。程序化能效测评技术文件收集阶段,同时创建用户交互界面,方便用户操作。利用TreeView控件可以直观显示文件和目录结构、文档中的类层次。Energy efficiency evaluation is an evaluation method to comprehensively determine the energy saving of buildings.As the first work of energy efficiency evaluation,the collection stage of technical documents is also the most time-consuming stage.Using the characteristics of easy access and rapid development of user interface of VBA,the technical document collection system is developed.The collection stage of technical documents is programmed.At the same time,a user interaction interface is created to facilitate user actions.Using TreeView control,the system can intuitively display the file and directory structure and the class hierarchy in the document.

关 键 词：能效测评 技术文件 VBA TREEVIEW 

分 类 号：TP391.13[自动化与计算机技术—计算机应用技术] TU111.195[自动化与计算机技术—计算机科学与技术]