I am not sure this is possible. I think that the "default" configuration is the first one listed, but I don't think that you can change configurations via the design table, just define them.
I guess I could be wrong. I have been wrong before....I know because..this is generally what it looks like.
It's looking like you're probably right, unfortunately. I am trying to develop a system where a non solidworks user can modify a spreadsheet and then generate a new model and print based on the desired configuration *as selected outside of solidworks in a spreadsheet*. It works if the "configurable" data are dimensions in a single configuration, but yes it looks like the table in excel is only a storage medium an interactive device when it comes to changing from one config to another.
it looks like the table in excel is only a storage medium and NOT an interactive device when it comes to changing from one config to another.
For a design table inside of a part use this ...
For a design table in an assembly use this ...
inside of a part:
Ok so if I use $configuration@part_name
then I can specify a different part name to any configuration that exists...but that doesn't necessarily allow me to make one or the other configuration active while using only excel.
Will this change the active configuration of a part that is being driven by the excel table?
If so, can you show me how it works? Because I can't picture it.
Now that I think of it, maybe I can picture it. You do bring up a good point.
If you have a linked body from another part inside your current part, I think that you can use the commands that Keith Carter has given you to change the configuration that is being used by the linked part INSDE your current part.
Same thing inside an assembly, you can change the configurations of individual components using Keith's method.
This might be a way to get what you wanted.
The Design Tables only allow you to control the dimensions, suppression states, etc. of the various configurations. They do not have anything to do with the "active" configuration.
I am not a macro or API person, but I'd be willing to bet that someone can get you setup where a non-SWX user can make their choices in a spreadsheet and it trigger or link to a macro or API that selects which configuration is made active.
Have you looked into DriveWorks? It might be just what you need.
How does one turn on a faucet from the fuse box?