Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations GregLocock on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro to make parts from a generic design table 2

Status
Not open for further replies.

LCform

Mechanical
Jan 13, 2016
139
Hi All

I am trying to figure out how to read data from a design table and apply it on an existing part(not built with a macro). imagine a bolt, that I have put the letter Dh for the head diameter in the dimensioning , and in the design table I have indicated different Dh for different designs. how should I apply these values to the parameter Dh in the part using a Macro ?

 
Replies continue below

Recommended for you

Hi,

You need to parse the excel (either using the Excel APIs or preferably via the ODBC/OLED source for the performance reasons). Then you can use this method to apply parameters: Configuration::SetParameters.

Thanks,
Artem
 
LCform,

If you have your data in a design table, you can easily select the version you want at assembly time. You can select multiple versions of the part for the same assembly. Why use a macro?

Can you enter your tabular data into the design table, and make a selection from there? This results in part, albeit, an easily re-configured part.

What are you trying to accomplish?

--
JHG
 
exactly what you said before drawoh, just since all the configurations are not saved as part, and only there is one, but I have to edit it every time for other configurations and copy and save them in another folder, but I dont know the method you mentioned , how is it done ?
 
LCform,

You can model a part with multiple configurations, and select a configuration at assembly time. For example, you model a cap screw. You create a configuration for each size and length. You insert the screw into your assembly. You change the size of the screw by selecting a different configuration. You insert another screw, and you change the size of that by selecting another configuration.

--
JHG
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor