Hello everyone,

I have to make a macro on solidworks to:

     1- create a BOM on an existing assemblie (intended number, detail numbering,.. then default config)

          -> easy to do with the macro recorder
          -> there already are BOM into the parts the the BOM is building without any problems

          -> the BOM is not on a drawing but a table of the assembly

     2- Save as this BOM on Excel using the name of the assembly (ex: 1995547.sldasm -> 1995547.xls for the BOM) in a specific folder

I wish I could integrate it to a JAVA software because I have do to that for thousands of files. I'm working with solidworks 2011 premium and I never used VBA before. I tried to use API from other forums...nothing has worked.

Best regards

Leon