| 基于Excel VBA编程的SolidWorks零件参数化设计 |
| |
| 引用本文： | 焦雯雯,潘建平.基于Excel VBA编程的SolidWorks零件参数化设计[J].机械工程师,2014(11):200-201. |
| |
| 作者姓名： | 焦雯雯 潘建平 |
| |
| 作者单位： | 1. 扬州市斯普莱机械制造有限公司,江苏扬州,225200
2. 康力电梯股份有限公司,江苏苏州,215213 |
| |
| 摘 要： | 结合Excel表格的处理能力和Solid Works实体造型功能,实现对非标零件的参数化设计。以涂装行业喷漆室某侧板为例,重点介绍了用VBA编程进行参数化设计的优势、过程和基本代码。研究结果表明,此方法实现了零件的自动生成,提高了生产和工作效率,减少了出错率。
|
| 关 键 词： | VBA Solid Works 参数化设计 涂装 |
Parametric Design Based on Excel VBA and SolidWorks |
| |
| JIAO Wenwen,PAN Jianping.Parametric Design Based on Excel VBA and SolidWorks[J].Mechanical Engineer,2014(11):200-201. |
| |
| Authors: | JIAO Wenwen PAN Jianping |
| |
| Affiliation: | JIAO Wenwen,PAN Jianping(1.SPRAY Machinery Manufacturing Co.,Ltd.,Yangzhou 225200,China; 2.Canny Elevator Co.,Ltd.,Suzhou 215213,China) |
| |
| Abstract: | Combined with Excel spreadsheet processing capabilities and Solid Works solid modeling capabilities,the parametric design of non-standard parts is achieved. A side of spray room is taken as an example to introduce advantage,process and basic code of parametric design based on VBA language. The results show that this method achieves automatic generation of parts,improves production efficiency and reduces the error rate. |
| |
| Keywords: | VBA Solid Works parametric design painting |
| 本文献已被 维普 万方数据 等数据库收录！ |
|
