基于EXCEL的零件管理方法

Management Method of Product Parts Based on Excel

根据产品的结构提出一种新的基于Excel的零部件管理方法,构成制造BOM,同时可以将这些数据导入数据库。通过VBA开发实现了零件的分类汇总、自动统计计算等功能,使用VBA开发EXCEL进行零件管理及工艺设计是一种很好的方法。

According to the characteristics of configuration of the product, a new management method for parts is presented based on Excel,and a making BOM tree is formed.Also these data are exported to a data-base.Some function such as classifying? calculating automctically and so on are developed through VBA language.