Modify material from excel

[bkline1]

I currently have an assembly model set up to be parameter driven by an attached excel spread sheet. With this parameter sheet I am able to drive the size and shape of all 7 parts of my assembly. I would like additional functionality to be able to control what material all 7 pieces are constructed from by simply modifying the top level spread sheet. Is this a possibility? I am new to Inventor, but I have been able to catch on quickly. I am aware of the capabilities of writing a macro using VB, but unfortunately at this time, I have not had any time to try and learn code writing. Any help would be greatly appreciated...

[Anonymous]

The material property can only be controlled by VB(A) or by means of iParts. Currently you cannot control the material by an Excel spreadsheet (unless it's an iPart). -- Sean Dotson, PE Autodesk Inventor Certified Expert http://www.sdotson.com Check the Inventor FAQ for most common questions www.sdotson.com/faq.html ----------------------------------------------------------------------- "bkline" wrote in message news:3605677.1075750369111.JavaMail.jive@jiveforum2.autodesk.com... > I currently have an assembly model set up to be parameter driven by an attached excel spread sheet. With this parameter sheet I am able to drive the size and shape of all 7 parts of my assembly. I would like additional functionality to be able to control what material all 7 pieces are constructed from by simply modifying the top level spread sheet. Is this a possibility? I am new to Inventor, but I have been able to catch on quickly. I am aware of the capabilities of writing a macro using VB, but unfortunately at this time, I have not had any time to try and learn code writing. Any help would be greatly appreciated...

[bkline1]

Sean,

Thanks for your reply... I actually used your web site's tutorials to impliment my parameter driven model. Thanks for the insight...