| 利用Office VBA自动生成相关仪表设计文件 |
| |
| 引用本文： | 郭非,范琳,付荣申,陈松华. 利用Office VBA自动生成相关仪表设计文件[J]. 石油化工自动化, 2012, 48(4): 63-65 |
| |
| 作者姓名： | 郭非 范琳 付荣申 陈松华 |
| |
| 作者单位： | 中国五环工程有限公司,武汉,430223 |
| |
| 摘 要： | 目前工程公司的仪表设计文件如仪表数据表、仪表索引等，多是人工手动填写或复制粘贴，速度慢、准确率低，一定程度上影响了设计文件的质量和工程进度。针对这一情况，介绍了利用VBA开发工具，开发出自动填写仪表数据表工艺参数和索引自动生成软件，工程实际应用表明该软件能够有效地减轻设计人员的劳动强度，提高设计成品的质量。
|
| 关 键 词： | 仪表数据表仪表索引Office VBA宏函数 |
Automatic Generation of Instrument Sheet and Index Realization with Office VBA |
| |
| Guo Fei,Fan Lin,Fu Rongshen,Chen Songhua. Automatic Generation of Instrument Sheet and Index Realization with Office VBA[J]. Automation in Petro-chemical Industry, 2012, 48(4): 63-65 |
| |
| Authors: | Guo Fei Fan Lin Fu Rongshen Chen Songhua |
| |
| Affiliation: | (Wuhuan Engineering Co.,Ltd.,Wuhan,430223,China) |
| |
| Abstract: | 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. |
| |
| Keywords: | instrument data sheet instrument index Office VBA Macro function |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
