利用Office VBA自动生成相关仪表设计文件  

Automatic Generation of Instrument Sheet and Index Realization with Office VBA

作　　者：郭非 范琳 付荣申 陈松华 

机构地区：[1]中国五环工程有限公司,武汉430223

出　　处：《石油化工自动化》2012年第4期63-65,共3页Automation in Petro-chemical Industry

摘　　要：目前工程公司的仪表设计文件如仪表数据表、仪表索引等,多是人工手动填写或复制粘贴,速度慢、准确率低,一定程度上影响了设计文件的质量和工程进度。针对这一情况,介绍了利用VBA开发工具,开发出自动填写仪表数据表工艺参数和索引自动生成软件,工程实际应用表明该软件能够有效地减轻设计人员的劳动强度,提高设计成品的质量。Currently, most of the instrument design files such as process data of instruments sheets and instrument index are filled manually or copied/pasted in the engineering companies with low speed and accuracy. As a result, the quality of design file and engineering progress are influenced somehow. Regarding to the situation, VBA development tool with the function of automatic generation of instrument sheet data and instruments index is introduced. According to the engineering application, labor intensity of the designers is effectively reduced and quality of design work is improved.

关 键 词：仪表数据表仪表索引Office VBA宏函数 

分 类 号：TP311.11[自动化与计算机技术—计算机软件与理论]