16 Replies Latest reply on Mar 6, 2015 9:36 AM by John Stoltzfus

    Exporting solidworks data to excel

    Tyler Holden

      Im trying to insert BOM data AND custom properties data from an assembly drawing or part drawing into a premade excel template.  I have custom properties such as part number, revision, drawing number, and all BOM info in the drawing (such as item no, qty, part#, description) im trying to create a macro that will take that data and insert it into the proper locations in a premade template.  OR i would like the macro to make a new excel spreadsheet with the information populated after the file is created.

       

      The document i am trying to populate is below (red arrows indicate what i would like populated)
      Capture01.png

       

      The idea is I want the information to populate this premade excel sheet which will save so much time manually plugging in the information.

       

      If anyone can help that would be outstanding thanks very much!!