Excel工作表驱动Solid Edge三维模型的VBA设计技术

VBA designing technology of Solid Edge 3D model driven by Excel working table

分析了使用Excel工作表、VBA(VisualBasicforApplications)和SolidEdge实现三维模型的工作表驱动问题 ,提出了从三维模型中检索出设计变量 ,并自动生成工作表单元格中相关内容 ,以及如何通过工作表数据更新SolidEdge三维模型的VBA程序设计技术。为产品的系列化设计、标准件和通用件的三维模型库的建立提供了一种非常实用的技术和方法。

Driving problems of working table for realizing 3D model by the use of Excel working table, Visual Basic of Application (VBA) and Solid Edge was analyzed. The retrieval of designing variables from 3D model, the auto-generation of relevant content in unit check of working table and how to renew the VBA program designing technique of Solid Edge 3D model by means of data of working table have been put forward. A kind of very practical technique and method was provided for the establishment of 3D model library of standard parts, common parts and product's seriate design.