CREATE EXCEL DATABASE FROM CUSTOM PROPERTIES

3D Design
1

Hello.

I'm looking for a vba code on SolidWorks that would allow you to increment an existing Excel file, custom properties of a part or assembly.

The increment is added line by line, one below the other, without deletion.

Thank you for your help.

 


capture_1.png
capture_2.png
2

Hello

If you have access to myCADtools, with the SmartBOM tool you can export all the properties of all the SOLIDWOKRS document configurations from the analysis of a folder.

Here is a tutorial: https://help.visiativ.com/mycadtools/2021/fr/SmartBom46.html

 


comment_rcuprer_les_proprits_et_leurs_valeurs.gif
1 Like
3

Hello;

I found some macros:
Here: https://www.codestack.net.../excel-functions/
And then: https://www.reddit.com/.../free_macro_to_manage_solidworks_custom_properties/
Please note that these two examples (not tested) require a license for "Document Manager" to be claimed on the Solidworks website (or through your Solid reseller)

Kind regards
Note: this post is a duplicate of the one in the discussion: https://www.lynkoa.com/...Lier the properties to an excel file

1 Like