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?
SolidworksApi macros