Abstract: Informations of the parts in the product should be extracted after finishing the 3D model of Bridge by CATIA software.The paper applies VB program to extract, order and store the related information of components automatically, and export to EXCEL file to generate the required standard BOM table.This method can improve design efficiency and achieve good application results.