AnsweredAssumed Answered

VBA removes many parts from SW model

Question asked by Wataru Abe on May 30, 2019
Latest reply on Jun 2, 2019 by Deepak Gupta



I am an amateur for both SolidWorks and API & VBA, but  MY BOSS gave me following theme.


Create a model for thermal analysis from 3D CAD model by SolidWorks

However, delete all unnecessary parts (bolts,nuts,cords,etc.) for thermal analysis.


<Thinking about>

1.Collaboration between Excel and SolidWorks.

2.Parts to be deleted are listed in Excel, but the number of parts is very large and

   It is difficult to list all

3.Since the part name has common parts such as xxx_bolt_001,xxx_bolt_002,xxx_bolt_003,....

   then, write “bolt” in the list of Excel and VBA deletes all parts including “bolt”


It would be helpful if you could present a sample.


Thank you in advance


I am sorry in English that is hard to understand.