基于Engineering Base VBA的线表路径信息自动填充  

Automatic Filling of Route Information in Wire Diagram Based on Engineering Base VBA

作　　者：刘超 陈奎 尹竹莹 Liu Chao;Chen Kui;Yin Zhuying(CRRC Zhuzhou Locomotive Co.,Ltd.,Zhuzhou,China)

机构地区：[1]中车株洲电力机车有限公司,湖南株洲

出　　处：《科学技术创新》2023年第10期77-80,共4页Scientific and Technological Innovation

摘　　要：手动添加线表路径信息存在耗时费力、准确率不高等问题。为解决上述问题,基于VBA开发了线表路径信息自动填充程序。通过该程序将原理图中的连接器、端子排信息导出到Excel;然后手动添加路径信息,通过Excel VBA自动核对格式;最后通过该程序将路径信息导入到原理图中。实际应用表明,所开发的程序能够提高工作效率和准确性。Adding route information in wire diagram manually is time-consuming and laborious,with low accuracy.In order to solve the above problems,an automatic filling program of route information in wire diagram is developed based on VBA.First,the developed program exports the information of connector and terminal strip from the schematic to Excel.Then,the route information is added manually and the format is checked through Excel VBA.Finally,imported into the schematic by the developed program.Practical applications have shown that the developed program can improve efficiency and accuracy.

关 键 词：VBA 路径信息 自动填充 线表 

分 类 号：U239.5[交通运输工程—道路与铁道工程]