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

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

能效测评是综合判定建筑物节能量的评价方法,技术文件收集阶段作为能效测评最先开展的工作,也是最耗时的阶段。利用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.