Fatih Mehmet Ozcan

Generate part from excel - working sample

Discussion created by Fatih Mehmet Ozcan on Feb 2, 2019
Latest reply on May 17, 2019 by Fatih Mehmet Ozcan

Hello everyone.


I prepared a small macro in Excel to generate a Solidworks part using cell values as dimensions. This is very basic but after you adjust it to your needs it might become very handy. Prompts user to choose a path to save as or goes on without saving. With entered values in specific cells, a part is generated from it's template.


Using a template part is more useful than creating a new one every time. You can use every kind of part you have as template when you change dimensions in code.


My file is in 2018, to use this macro in another version create a part with the dimensions with same names as in code.


All feedbacks are welcome.