I have a list of several hundred parts that I would like to be able to extract the assigned material, density, and mass properties for without manually opening each individual part and transcribing the info.  These are individual parts, not in an assembly so I can't use the usual method of BOM tables with properties exported.

Is there some macro code that can be generated to do this?  Ideally, the code would look in a target folder and open each part in SolidWorks in the background to extract the material, density and mass values and export them out to an Excel file.  I have some VBA experience by my coding skills are not up to this task and some older code I found from like 10+ years ago errors out immediately.

Any help would be greatly appreciated 😊