基于Excel VBA和AutoCAD的滚动轴承参数化比例图绘制方法  

A method for parameterized scale graph drawing of rolling bearings based on Excel VBA and AutoCAD

作　　者：张雅娜[1] 徐巍[1] Zhang Yana;Xu Wei(Wafangdian Bearing Group Co.,Ltd.,Wafangdian 116300,China)

机构地区：[1]瓦房店轴承集团有限责任公司,辽宁瓦房店116300

出　　处：《哈尔滨轴承》2020年第3期43-45,共3页Journal of Harbin Bearing

摘　　要：本文通过Excel VBA二次开发功能,建立了Excel与AutoCAD的连接,实现了通过Excel文件中单元格数据自动绘制AutoCAD比例图的功能,可减少大量重复工作,提高设计效率。In this paper,through the secondary development function of Excel VBA,the connection between Excel and AutoCAD is established,and the function of Auto CAD scale drawing through cell data in Excel file is realized,which can reduce a lot of repeated work and improve design efficiency.

关 键 词：滚动轴承 Excel VBA Auto CAD 

分 类 号：TH133.33[机械工程—机械制造及自动化]