AnsweredAssumed Answered

How to read items from a material database?

Question asked by Andreas Killer on Jan 15, 2016
Latest reply on Nov 12, 2020 by Jorn Bjarning

I'm developing a macro to create SLDLFP files from our component list (in Excel).


Creating the SLDLFP files, edit the sketch, set new dimension values, etc. is no problem, but the material part is not nice.


In our custom SW material database we have many materials with extended names, so I have e.g. to use this to set the material properly:


Set swApp = Application.SldWorks

Set swPart = swApp.ActiveDoc

swPart.SetMaterialPropertyName2 "Standard", "K:/Software/Solidworks/Vorlagen/Materialien.sldmat", "1.4404 (X2CrNiMo17-12-2)"


In our Excel list only the part "1.4404" is available, but SetMaterialPropertyName2 needs the extended name.


I've seen that I can get the material databases with swApp.GetMaterialDatabases


I wonder if there is a way to read all materials (items) from a database (into a collection or Array)?


Then I could search for the material from our Excel file in all items and get the extended Name.


Regards, Andreas.