利用EXCEL的VBA实现CAD图纸批量修改  

Using VBA of EXCEL to implement batch modification of CAD drawings

作　　者：王同俊 WANG Tongjun(China Information Consulting&Designing Institute Co.,LTD.,Nanjing 210019,China)

机构地区：[1]中通服咨询设计研究院有限公司,江苏南京210019

出　　处：《通信与信息技术》2022年第5期51-55,共5页Communication & Information Technology

摘　　要：CAD图纸是通信工程勘察设计的重要文件,是工程建设的主要依据。通信基站工程CAD图纸主要包含设备布置图、天馈系统图、方案说明、工程量表等。虽然每一个基站的设计图纸不具备一致性,但是每个基站的方案总有一些共性的内容。通过EXCEL的VBA功能实现大批量的CAD图纸修改,生成半成品的设计图纸,然后设计人员在半成品图纸上加工,提高设计效率。CAD drawings are important documents for survey and design of communication engineering and the main basis for project construction.The CAD drawings of the communication base station project mainly include the equipment layout,antenna feed system,scheme descriptions,bill of quantity,etc.Although the design drawings of each base station are inconsistent,there are al⁃ways some common elements in the plan of each base station.Through the VBA function of EXCEL,a large number of CAD drawings can be modified,and semi-finished design drawings can be generated.Then the designer can process the semi-finished drawings to improve the design efficiency.

关 键 词：EXCEL VBA CAD 批量 效率 

分 类 号：TP3[自动化与计算机技术—计算机科学与技术]