I am looking for some help creating macros in excel/solid works. Let me give you a brief explanation of the project I was assigned, and what I am trying to do. One of our major product lines for the company I work for is machined plastic rings. We currently have ~1,000 different styles, with endless configurations in each style. The dimensions of the ring are based of equations. In most cases I will be imputing a cross section and I.D. dimension, which will drive the equations to create the ring. I just finished drawing all ~1,200 rings in solid works, and linked them to appreciate equations in excel. This is working great, however I was asked to create a button/macro in excel that will do the following.
Open/Save/Close the model and drawing, the model and drawing should be saved as the part number which is derived from the dimension of the part and is located in the cell label part number in excel. I created a example ring, for reference(See attached excel /solid works file). And to make it even more difficult, I need to destroy the link to the design table when it saves each part. Any help I could get would be greatly appreciated!