I would like to use Visual Basic to automate the creation of some of the input to HyperSizer -- specifically the creation of 128 unique components for each of 10 different projects within a database. All of the properties for each component would be pulled from columns of data in Excel, and that component data would reside on a separate worksheet for each project, but all within the same workbook. The data that I want to specify is X Span, Y Span, Nx, Nxy, and normal pressure, leaving the default values for all other input. In the particular exercise that I’m doing, there is only one group per project, that happens to be the same for all 10 projects. So creating all of the components for each of 10 existing projects is the only part that I need to avoid having to do manually.
I know there’s much more that I could automate, and a more general Excel setup and VB code to execute trade studies would be useful in the future. But I think I'll be able to get a lot of use out of this one specific automation, so that's all I really need for now. (TIA)