基于VBA的轴承选型与校核系统开发  

Development of Rolling Bearing Selection and Checking Systems Based on VBA

作　　者：田建平[1] 张九洲[1] 张杰[1] 

机构地区：[1]四川理工学院机械工程学院,四川自贡643000

出　　处：《四川理工学院学报（自然科学版）》2009年第5期101-103,共3页Journal of Sichuan University of Science & Engineering(Natural Science Edition)

基　　金：四川省自贡市科技局重点科技项目(08C01)

摘　　要：滚动轴承的设计主要包括选型和校核计算,传统计算方法需频繁查阅手册、反复计算。文章在AutoCAD环境下利用其内嵌的VBA进行二次开发,完成了选型与校核系统设计,并在系统中充分考虑影响选型的多因素的程序化算法及表达方法。同时介绍了表格数据的处理方法、各模块的功能等。经过测试,系统运行稳定、计算准确。Rolling bearing＇ s design includes calculation of selection and check. The method of traditional calculation needs frequent access to manuals, repeated calculation. This paper uses it＇ s embedded VBA for secondary development in the AutoCAD environment, Design of the Selection and checking system is completed. And many affected factors of the selection is talked fully into account about programmed algorithm and expression in system. At the same time, method is introduced about treatment of table data, the module~ functions, etc. Though testing, it is stable operation and accurate calculation. improving the efficiency of the traditional system.

关 键 词：滚动轴承 选型系统 AUTOCAD VBA 

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