API Solidworks in VBA

Project will be explained. A program in VBA Solidworks that will make a product which will be having three categories and each one will be having three subcategories so the dimensions should change automatically as soon as the user enter the model number. Excel table should be of use so that the program can be updated using excel if required.