利用Office VBA自动生成仪表数据表  

Use Office VBA to Automatically Generate Instrument Data Sheet

作　　者：田忠 张金亮 薄涛 TIAN Zhong;ZHANG Jinliang;BO Tao(Shandong Tianli Technology Engineering Co.,Ltd.,Jinan,Shandong 250000,China)

机构地区：[1]山东天力科技工程有限公司,山东济南250000

出　　处：《自动化应用》2023年第11期187-189,192,共4页Automation Application

摘　　要：仪表专业的仪表数据表设计工作大多采用键盘输入或复制粘贴的传统方式填写工艺数据,该方式存在设计用时偏长、错误率偏高的问题,为此,本文采用Excel VBA开发了一系列能自动生成仪表数据表和索引页的应用程序,解决了在设计过程中仪表条件输入与修改工作量较大的问题,缩短了设计时间。Most of the design work of instrument professional instrument data sheet adopts the traditional way of keyboard input or copy and paste to fillin the process data,which has the phenomenon of long design time and high error rate.Aiming at this traditional method,this paper introduces the use of Excel VBA to develop a series of application programs to automatically generate instrument data table and index pages,which can solve the problem of heavy workload of instrument condition input and modification in the design process and shorten the design time.

关 键 词：仪表设计 仪表数据表 VBA 仪表索引 

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