基于Creo和Excel二次开发零件参数化设计系统  

Parametric Design System for Secondary Development Parts Based on Creo and Excel

作　　者：胡迪 罗辉 张伟 申逸骋 HU Di;LUO Hui;ZHANG Wei;SHEN Yi-cheng(Intelligent Manufacturing Institute of Hefei University of Technology,Hefei 230000,China)

机构地区：[1]合肥工业大学智能制造技术研究院

出　　处：《机械工程与自动化》2020年第1期31-34,共4页Mechanical Engineering & Automation

基　　金：安徽省重点研究和开发计划项目(201904a05020016)

摘　　要：分析了参数化设计的流程,利用Creo提供的VB API接口,研究了在Excel VBA环境下二次开发Creo的关键技术。在此基础上开发了零件参数化设计通用系统,不仅可实现具体零件的参数化设计,同时具有较强的可扩展性,无需修改源码即可完成参数化设计零件库的维护,并给出了工程应用实例。By analyzing flow of parametric design,using the VB API interface provided by Creo,the key technologies of secondary development of Creo under Excel VBA environment were studied.Based on this,a general system for parameterized design of parts was developed.This system can not only achieve the parameterization of specific parts,but also has strong scalability.It can complete the maintenance of the parametric design parts library without modifying the source code,and gives examples of engineering applications.

关 键 词：参数化设计 Creo 二次开发 EXCEL 

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