基于VBA的AutoCAD与Excel之间的数据通信  

Data Communication Between AutoCAD and Excel Based on VBA

作　　者：张治娟[1] 武福[1] 杨智文[1] 陈晓强[1] 

机构地区：[1]兰州交通大学机电工程学院,甘肃兰州730070

出　　处：《工业控制计算机》2013年第12期27-29,共3页Industrial Control Computer

摘　　要：基于VBA宏控制语言,利用AutoCAD ActiveX对象接口技术编写相应的程序,可将Excel格式的数据或文本字符直接导入到AutoCAD中,自动生成相应的图形,可实现自动绘图的功能。同时,通过编程从AutoCAD图形中提取坐标值和距离等参数,并导入到指定的Excel中,从而实现了Excel与AutoCAD间的数据通信。根据介绍的设计思路,可以编程添加新的绘图和计算功能,对AutoCAD和Excel的二次开发具有一定的借鉴意义。This paper is based on VBA macros control language, and the AutoCAD ActiveX object interface technology is used to write the corresponding program,the data or text characters in Excel format directly imported into AutoCAD,and automatically generate the corresponding graphic,so that achieve the automation of drawing.It can also be programmed to achieved that extracting the coordinates and the distance from AutoCAD drawings,and import into the specified Excel,so as to realized the data communication between Excel and AutoCAD.According to the design ideas introduced in this paper,it can be programmed to add new graphics and computing capabilities.

关 键 词：VBA EXCEL AUTOCAD 数据通信 

分 类 号：TP391.72[自动化与计算机技术—计算机应用技术]