Using Excel in conjunction with SolidWorks

Hello

Does anyone have an example of an excel file controlling a part or an assembly?

I'm looking for an example, allowing to manage much more than dimensions, such as deletions, cancellation of deletion of functions, etc...

Thank you

Hello

All you have to do is use properties, import them into your part family, and manage the state (0/1) of the functions to be deleted from the equation manager with conditional formulas.

Check this out, it may help:

http://www.lynkoa.com/tutos/import-export-formats-neutres/pi%C3%A8ce-param%C3%A9trable-avec-les-propri%C3%A9t%C3%A9s-personnalis%C3%A9es

 

Edit: It all depends on what you are looking for, on a single configuration, the above solution works very well, on the other hand if it is possible to use several configurations to remove functions it is easier. I've already made a 3D that can be set according to the custom properties pane with a single configuration and it works very well.

1 Like

Hello 

For these different functions, I use the families of parts associated with custom properties.

It's quick and easy

2 Likes

Hello

Watch this video and do what you will know

https://www.youtube.com/watch?v=aGZTv99R4hE

may the force be with you.

 

2 Likes

Hello

Which version are you under???

Solidworks 2017 Pro Sp3.0 version.

I remind you of my question, in order to control a SolidWorks 3D model through EXCEL, use of VBA on Excel, I can control dimensions but I would like to control functions.

 

 

Well the principle remains the same, when you have opened your Excel file you can select your functions as you select your dimensions then you will have the NS "not delete" and S "delete".

1 Like