AnsweredAssumed Answered

How to export material property to excel

Question asked by Jonny Levelius on May 13, 2015
Latest reply on May 14, 2015 by Adam Hoffman

I am writing a long macro that lists the current part/assembly information (Description, Material, Job Number, Client, Location, etc.)  in order horizontally onto an excel spreadsheet.  When I click the button SolidWorks sends this information to the master part numbering excel spreadsheet.  It grabs the next available row and assigns it a new part number.  I can do all this but I can't get the material custom property to show up in the spreadsheet.  What I want it to say, for example, is "AISI 304" but instead it says "SW-Material@Part1.sldprt".  How do you call that custom property and set it equal to a cell in Excel?

Outcomes