基于VBA技术的变压器铁心叠积图绘制

The drawing creation of a transformer core laminations based on VBA technology

利用VBA面向对象的编程环境、强大的计算和开发能力与AutoCAD丰富的图形处理功能 ,使VBA成为一个内嵌式的控制器 ,与AutoCAD共享内存空间的数据 ,如Microsoftoffice软件 .通过对VBA宏的属性的设置 ,把这一技术引入到变压器CAD铁心叠积图绘制中 .首先推导出在极坐标下的极厚和角度的公式 ;然后使用VBA技术对变压器铁心数据进行处理 ,并与EXCEL数据库的信息交换 ,实现对数据库的查询、修改和追加 ;

With the help of the object oriented programming environment, strong calculating and developing ability of VBA technology and the abundant graphics processing function of AutoCAD, VBA has become an in-line controller and can share memory data such as data of Microsoft office software with AutoCAD. By setting the macro attributes of VBA, this technology is introduced into the drawing process of transformer core laminations in a transformer design. The formulae of the step thickness and angle in polar coordinate system are derived.By applying VBA technology in the data process for the transformer core, the result data are saved in the EXCEL data-base, which can be modified, inquired and added. The drawing of core laminations for a practical transformer is finished consequently.