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

基于VBA宏控制语言,利用AutoCAD ActiveX对象接口技术编写相应的程序,可将Excel格式的数据或文本字符直接导入到AutoCAD中,自动生成相应的图形,可实现自动绘图的功能。同时,通过编程从AutoCAD图形中提取坐标值和距离等参数,并导入到指定的Excel中,从而实现了Excel与AutoCAD间的数据通信。根据介绍的设计思路,可以编程添加新的绘图和计算功能,对AutoCAD和Excel的二次开发具有一定的借鉴意义。

Data Communication Between AutoCAD and Excel Based on VBA

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.